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

It works well - now if I could get the text box to display the incremented value in 'realtime'. Thanks for the tip. Jim

Thanks. until a better way comes along, I'll start investigating the method you prescribed. Jim

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

No, it's not working. It's actually making no difference. BUT, more precisely: The background image I have in my test is stable. It stays put as expected, and so do the few test fields that I've dropped in to the report. But it seems to make no difference on this other report which I'm...

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

Sharon, Are you able to decipher that from the Select statement I provided? Because there are not duplicates allowed on any of the tables designated with a one-side primary key. 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, thanks, but I do need to be able to add a new record when needed. What you instructed works for the next record button, but dims the new record button. Please help, Thanks, Jim

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

Thanks for your response. I will try to describe just the problem I am having, as best as I can. I have a main form. WIthin that main form is a subform. Within that subform is another subform. That nested subform has a button which popus up a form. That form, which is supposed to display a...

Thank you for your response. But even though I've since changed the data base to another state which still doesn't work properly, it was never the case for any field in my "main form" to be related to any field in the sub form, except for "CustomerNumber". Even then the subform was getting the...

Hi again, More accurately, the pop up form displays the same data for every record, but NOT on the pop up form itself, only in the table. Please help, Jim

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

Ghudson, Yes, I've visited this site before. Not only that, but I have downloaded the the Access Web 2000. I opened it and did some looking around, but don't remember getting help for what I needed at the time. I'll give it another, closer look. I want to ask you though, about my project, do...