Search results

OK Access wizards, I need your help. I have a form that sums the fields in the form (in the footer obviously). Also in the footer I have a label control that I want visible or invisible based on whether the sum is positive or negative. I'm having trouble with where to put the 'trigger' to get it...

Thanks Paul. I see how it would use associations if an existing document was inputed as the hyperlink, but what if you wanted to launch into a new document?

OK. This may be a no-brainer and if it is then perhaps that would explain the state I'm in. I know you can launch MS Word from Access but is there a way to launch a non-specific word processor? In other words, perhaps utilize the user's associations in Windows to lauch whatever their word...

Is it possible to invoke the Printer Dialog box to print a report without ever actually opening the report? For example, DoCmd.OpenReport acNormal sends the report directly to the printer presumably without opening it (if it does open, it's too quick to see). I want the same functionality but...

Yes actually I had thought about creating a 'print table' of sorts for that purpose but was trying to keep the db as streamlined as possible. If the way I have it now ever causes a problem, then I'll probably go that route. Thanks again for everyone's help.

Boyd, Thanks for your help. The problem, just as I thought, was with using the EmpID field as a filter in the query. Without it it works fine. My only hesistation with this and the reason I didn't go this route in the first place is that there are many front ends and if two people are doing a...

Yes it is. The data is going through a query to a table. That's why I'm doing a requery to make sure it took before opening the report that pulls from the other query.

I have a continuous form that after selecting a group from a combo box, should give the user the option to print a report associated with the selected records. The user chooses which to print from the displayed records by simply checking on a yes/no checkbox for each record. The print button...

They are linked to an Access back end. What I need to do is update the location of the back end but I can't seem to get it to show the linked tables in the first place.

Any ideas from any others out there?

Anybody else?

In both cases, the screen where you are supposed to select the tables you want to update does not have any table listed but I know for a fact there are linked tables in the database.

Yes. You can get to it that way or through the Tools, Dabase Utilities menu items.

I know quite a number of the tables are linked. (The arrows are there although on my computer they are black) My company has used this database that I created for several years with no problem and as I said it is functioning fine so I know it sees the linked tables. They are just not showing up...

Can anyone tell me why none of my lnked tables are showing up in the linked table manager screen? The database functions fine but I need to change the location of the back end and can't get the tables to show up in the linked table screen. Help!!!!!

OK I'm throwing a challenge out there to everyone. I am overloaded and trying to figure this out is driving me nuts. What I have is a table with a list of names as such: James Smith Susan E Jones Gary Duane Thompson etc. etc. Note the variability in how much of the name is given. What I need...

I've created a database for a group and they have requested that in one of the data entry forms (a continuous form) that they enter the data vertically instead of horizontally. What I mean by this is they want to jump from one record to the next but within the same field as they enter data. I...

Bravo! Thanks. I had to add and additional field to make sure the L and R alternated but that did it. Cheers!

Brian, Thanks for the help. Unfortunately, it doesn't appear to work either. Any other ideas? John

I have a kind of peculiar sequencing issue with a query. I have several machine designations: A1 A2 A3 .... A10 A11 A13 B1 B2 etc. but the last group is designated as right or left...in other words C1R C1L C2R C2L ... I am trying to get the query to put them in order such that they appear...