Search results

It's been a long while since I've visited here. I'd like to do the following, and don't know where to start. I have looked in the sample re-usable code section, and it's possible something was looking me square in the face, but I didn't recognize what I needed. I need to: Search for a...

Hi, I'm trying to figure out how to count the occurrences of one of 3 fields in a table, using a query. The table, though rather long, has only 3 fields. I'm using Access 2000, and one of the fields has an alpha value. That alpha value may occur many times. There is another field (numeric)...

Hi, I am looking for a way to create a simple form (something I can do), from where I can manipulate (create, copy, open) simple text files which already exist on my hard drive. Can someone shed some light on the process or point me to an Access tutorial which covers that very topic? If I...

Hi, I have a simple form, where I have 1 field, that gets converted in two other unbound text fields on the same form. No tables or queries involved here. I want to add a button that increments textbox1 by .01 as long as I keep the button pressed down, instead of having to click each time...

Hi, I have a report for this project, where I need to keep the header information perfectly in tact, should the details section be so excessive it needs to write more than one page. Critically, I have a background, which the user created. I've included that background, so it looks just like...

Hi, I want to synchronize a main form to a pop up form. I have seen many examples of main form to subform, and subform to subform, but I don't think that provides enough for me to logically think out what's needed to synchronize my main form to my pop up form. Please help, Thanks, Jim

Hello, I am making some good progress with the help I've gotten here over several months of trying to put this project together. I now have a form based on a query which draws from 4 tables. I'm told that if I try this that I may not be able to update my tables. Sure enough, there is one table...

Hi. I have created a query, which draws from several tables. One of these tables is a pop up form, where details are entered (the pop up form draws from a query also, not directly from a table, as I've been advised against). The results in the pop up form link to a subform (on which I have...

Hi, I don't know how to explain my question, so I couldnt even do a search for it. On a pop-up form I have, I am able to click the next record button, and it will NOT stop at the last record in the set of records for that given "many side" number. Instead, it creates a new, blank record, and...

Hi, This database is continually giving me problems. I've even included a graphic of my relationships, so you know the set up. I have a Main form. In that main form is a subform Within that subform is another subform. I don't wish to try new designs anymore. Every time I do, get more...

Hi, I have the error message: "You cannot add or change a record because a related record is required in table "Service" " (Service is a subform off my main form. I have a tab control, with two tabs. The second tab is for the service details form. The first tab is the actual "Service"...

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."...

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...

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, 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...

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, 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...

Hi. I thought I had this problem solved. I have a query which calculates beginning and ending mileage, and displays the miles driven for that record. Then, I decided I wanted a total of ALL the miles to be displayed onto the single form, which has a single underlying table, (with my 2...

Hi, I have Access97, which I upgraded to Access 2000. Now, my Access97 had at least the Office Service Pack 1 installed. But, I can't update my 2000 version now, with the service pack 1 for Access 2K. Also, I am running this on NT 4. I understand that the Service pack for Access 2K is...