Search results

Thanks so much ! That part of my problem works now ! Ineed I was using the name of the table field, and corrected it to find that it now works. Thanks, Jim

GHudson, No, now it's telling me that it can't find the parent form, when I try the syntax you provided. You told me to try: Forms![frmCustomerCarData]![txtUniqueCarID] (actually I have it Forms![CustomerCarData]![UniqueCarID] ) And then when i click on the button on the subform, to open...

GHUDSON, I was able to get it to open without errors, but my new 'problem' is that the "UniqueCarID" number does not get reflected into the new pop up form field". While creating the button, I was under the impression it would do this for me. As far as proper naming conventions, please point...

Hi, I have a problem when I click on a command button on my subform named "mysubform", it gives me an error that it cant find the name of "mysubform". The error: Run-time error '2450' "MyDatabase can't find the form "mysubform" referred to in a macro expression or Visual Basic code."...

Perfect ! Though a simple fix, I wouldn't know where to begin to find the solution, if it wasn't for this forum. Thanks, Jim

Hi, Can you direct me to an example of this ? Thanks, Jim

Hi, I have a command button, which pops up a form. The form has two fields. One is the customer number, and the other is "Notes". The user is to be able to enter notes on this particular customer, in a field specified as the "memo" type. I created the button with the wizard, and thought it...

I now have another problem with a different combo box in my database. That problem which is now ironed out was a combo box in my sub form. I had already made a combo box in my main form to server as a look up field. After much ado, it finally worked, in looking up a record, based on customer...

Yes, it's all ok now. I don't know what my big confusion was yesterday, but after trying a million things, I tried what you prescribed in your reply, and it works now. By the way, what's the difference between a combo box and a list box ? Thanks, Jim

Hi, It seems no matter how many databases I set up, where I need to use a combo box, that either the setup or the concept of it baffles me. And now again, I have the same issue, likely one that's been answered before, but looking through my previous posts and others on combo boxes, I just...

Hi, Thanks for responding so quickly. I know about tables. The data in all of my tables is entered only once. This is done with the help of primary keys, and relating one table to another by a particular field. I mentioned the "basic" layout of my database which has been in service for a...

Hi, I've been working on this database, where basically, I have 3 tables and 3 corresponding forms. The first table: CustomerData has one primary key. The Other, CustomerCarData has 1 pk, but is also the many side of 'Customer Data". The 3rd table is 'Service'. with 1 pk, and 2 'many...

Hello. I'm using Windows 2K, and Office 2K, with SP-3. I don't know if I'm using ADO, DAO, and would appreciate knowing a little more about that. Thanks, Jim

Sorry folks, I think I messed up when creating the new form, and somehow didn't tell it which table to link it to. BUT, please stand by as I may have some other questions regarding this service database. Thanks, Jim

Hi, I have a database, which has a main or intro form. When you click main, it goes to the main data entry/processing form. I just put a subform on the main intro form, and a lookup combo box to go right to the customer record on the subform. but I get a debug. When I click on debug, it has a...

Hi. I tried to create a report in Access to look somewhat like an already existing receipt, which has grid lines. Now, the grid lines are mostly even rows and columns, except for a few. Now, it would be very easy to mimic the basica report layout in Excel, and think that's how to best create...

Hi again, I got it ! I had to hunt around a little bit, and learned something new. Thanks for your help, Jim

Hi, It's not working for me. Likely it's my design. I added the combo box directly to the form, using the wizard. I find no place, not even in the linked table, to where I can sort the records one way or another. I do not believe I have a query driving the form. Even if I sort the form...

Hi, I have just put a combo box on my form. It works just like expected, for what I want to do, but what would make it ideal, is if it could be sorted by name. The way it is currently sorted, is numerically, according to customer number, but I have only one field in my combo box (the last...

Yes ! That's it ! It works. Thank you, Oh thank you, Jim