Ok, I have 2 questions that I am struggling with. First, due to limitations of the built-in lookup dialog box, I have created my own. The form opens on cntrl+spacebar likes its supposed to, and I can select an entry and click the OK button for it to be inserted into my primary form.
First...
Thanks for the information, unfortunately, due to the way the files and folders were originally set up, before me, I don't think I can have access add the extensions. The files are named using a person's social then .med.pdf, there are two dots in the file name. We have changed the process to...
Ok, I need help. First I am running Access 2000 on a Windows 7 computer, don't laugh, I know. I have a database called testing containing a table called Table1. The table consists of a single field, FileName. I am trying to code a module to look in a particular folder and copy all the files...
Ok, I know how to create a pushbutton to run a query and return a tableview, or even open a report, and this works when everything is in the working directory. I have, however, run into a problem when trying to open a report not in the working directory, since not everyone uses the same working...
Could you also help me with some code that if the person is not found in the second table, now I have other tables involved, that it gives a custom error message?
The frm.SS_#.locate("SS_#",SSN)almost worked, but I got an error message that there wasn't a field called "SS_#" in my table, which since in quotes I was able to leave out the "_" and it worked. I don't mind them changing the preference to another record in the table, but now the button works...
Ok, I know this is simple, I just don't know what I am doing wrong or missing. I am using paradox 5. To simplify matters, I am using 1 table and 2 forms, x and y. Form x displays the social security number, last name, first name, and middle name of a client. Form y displays the same and...
My apologies, but I think I may need that example. Where do I set the field variable? How do I use the variable in a query where the variable equals the value in the field as displayed on a form?
Also, while I have someone who knows how to do this, say instead of a query, I would like to open...
I have tried the same thing. No luck. I assume it will take a bit of SQL, which is fine, just need to figure it out, or find someone who knows how to do it.
1) Yes, the records in one table are in the other.
2) No, there may be more than one person with the same last four digits, but I am also joining the tables by dates of birth. The likelihood that someone will have both information the same in our tables is slim at best.
I know there has to be a way to do this, but I just can't seem to find it. Is there a way to form a query using the data displayed in a field in a form as the criteria? In Access I would just use Form![fieldname, or something to that affect.
Is there a way in a double query (a query involving two tables) to use example elements to match records based on partial data in a particular field. For instance, I have two tables, both with a field for social security numbers. But the first table only has the last four digits. I want to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.