1,557 Topics
| |
Hello, I'm a novice at microsoft access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal … | |
Hello, I'm a novice at [URL="http://www.daniweb.com/techtalkforums/thread67883.html#"]microsoft[/URL] access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal … | |
I have been using a program that I wrote years ago. It is an Excel sheet that collects data from a MS Access database using queries. Everything was fine until this year (2007) My old queries work but none of my new ones.So I made a copy of and old … | |
I get a "too many indices" message when I try to access a sequel table via MS Access. Is there a work around for this.:rolleyes: | |
| I ahve a client that exports an mdb file to a server folder from Access and their website auto updates with this information, it there a way to expot a file from FM8.5 that will do the same? TIA mac |
:cheesy: Help... I am not exactly a novice, but I am. I have been secured to develop an Access database for a very small organization. There are a total of 13 members who will be updating and pulling reports from this DB, so I am not overly concerned about heavy … | |
Hi! I am creating a database for a class. It is supposed manage the hospitals Drug inventory as well as the patient's information and what patient is on what drug. I created a drug table (with drug_id, num_in_stock, and num_prescribed) and a patient table (with patient_id, name.. blah blah blah) … | |
I have a very simple table in "MS Word" (all fields are text fields) and I want to transform it into an "Access" table. How can i do it automatically? Is there any macro or a programm code that would allow me to do it automatically? (In the future I … | |
I'm new to FileMaker Pro and am very very puzzled. The words E-Mail Campaign Manager suggested it would have powerful tooks to send e-mails. However, my staff seem to be unable to find a way to sort e.g., for all "journalists" in "Taiwan", and then send emails to all the … | |
Hi, how can i display images in a form in Ms Access 2003. I have fields in a table and path of images. Thanks | |
Hi Folks, I'm trying to pass a string between two different forms in ACCESS with code, and I'm having some difficulty tracking down the proper way to do this. Assistance in completing this task is greatly appreciated.. Thanks in advance! - Jordan Here's what I want to accomplish: [B]Form 1: … | |
I'm try to let a form have a drop down bar (linking to a field in a table) which when any name within it is click it will display on the report that area | |
Hey all, I'm using Access in conjunction with C# and ASP.net 2.0. I can't get the following query to work in Access, and I have no idea why it's throwing a syntax error. Any help would be appreciated. Thanks! [code]SELECT a.name, a.origDate, b.firstName, b.lastName, c.priority FROM afmMain AS a INNER … | |
Hey all, i am new to these forums and was wondering if anyone could offer some advice/help Currenlty we have MS Access databse which was created well before i started, this database has all our work instructions mixed into it. Unfortunately it isn't the easiest thing to navigate and seeing … | |
I'm creating an app with an Access database backend, and I seem to have encoutered two problems that I can neither explain nor solve. 1. When I run the app, there is a blank record that I can neither edit nor delete, and I am forced to click to add … | |
Is there a easy way to import emails from outlook to a access table? I know I can go file, get external data, etc but I am looking for a macro that will do it or some code for a button to do it. Thanks in advance for any suggestions … | |
Please let me know the code to populate the data from Table to Forms. What's the code for assigning values to Form buttons? | |
I need help. I need a MS Access Database to submit for my final project in my Database Design class. Does anybody have one they could discuss with me? | |
We're using Access 2000 and have 9916 entires. I've been told we're limited to 10000 entries. Is it so? If so, can we upgrade to a new Access? Or, must we go to a more sophisticated database? What's a body to do?? | |
Hi All, I'm trying get access to a Firebird BLOB field. I have linked the input table using ODBC(FB 1.5). I have tried to extract the blob content various ways, so far unsuccessfully. Is there any way I could declare the BLOB_get, BLOB_open FBCLIENT.DLL functions in MSAccess code module? If … | |
The following SQL results in an "invalid procedure call" message. SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1 where (((ViewtimeHCPick1WRes1.X)>2)); SELECT ViewtimeHCPick1WRes1.X FROM ViewtimeHCPick1WRes1; works fine. ViewtimeHCPick1WRes1 is a query. X is a calculated field that results in a number of format x.y or x. Any suggestions as to why the where clause is … | |
Hi, I'm trying to use a Do Loop to look at 2 seperate tables. It needs to check the value in one field on the first table. If it finds a "T" it should look to a field in the other table and count down 3 rows. Then it needs … | |
Dear Guys, I developed one application using Microsoft Access2003, I use to MDB file, one is time_db.mdb and time.mdb and link these two databases. I put my time_db.mdb in the shared folder [URL="file://\\avss-srv"]\\avss-srv[/URL] and install the time.mdb in the client pc. The time.mdb is reading the database from time_db.mdb. When … | |
Hey All, I have created the following code in my data base. It works correctly except that the email it creates is in the rich text format. I want it to be in plain text format. The default settings in outlook are set to plain text, but my code seems … | |
Is there any way to use the sendobject command to send a report as a pdf attachment rather than an rtf attachment. I am able to use the print object command and get this to work if I make the acrobat distiller the default printer. This way forces me to … | |
I have a subform on an Access form and in some cases default (or auto fill-in) fields in the subform from values in the main form. I don't want to default the values unless the user tabs to the field in the subform. What I've found is that if I … | |
Hey there! Wondering if I might get some help. I have been asked to add some things into a database that we have. I have inserted a subform in a main form, with the correct links, etc. Data will be entered into both the main form and the subform. I … | |
Hey, I need to implement a database using MS Access. I am currently using a java platform and I dont know how to access the information stored in the database. I have used MySQL database in previous programs but it gave me some problems when loading the application. Can anyone … | |
Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example: id Time Code Price Res … |
The End.