I have started to migrate users from NT4 to Active Directory/WK3 Server. When a user under NT has an Access app open (creating a lock file), and, as a Active Directory user, I also try to open the app - NOTHING HAPPENS! But when I open access, and point to the app through file open, it works...
What is the VBA code to run the Export cmd from the File menu when i have a report on the screen (can I do it all at once?)?
I need to loop through a form, calling each line to export that report saved as snapshot file on the network (or word)
open form x, start at top
loop..
open report...
Try not using any queries. Go into them, and view them as SQL, then copy the line to the DataSource of the form, then delete the query because it will no longer be needed.
I am using an old MSPress Access97 ref book. Can anyone suggest a newer reference book for Access/VBA Application development? (especially the newer stuff like Web Pages linked to the Access Database)
I have been able to open the report with the filter and, if still open then E-mail it like below, without the report regenerating without the filter... sort of like this...
strTitleLine = [lngID] & " Is my person TILTE"
' in the on_open of the rptGOData, set this as the title...
I have a form that displays a record, and it has a "clear" button on it. When the "clear" button is pressed, I wish to secretly copy the entire record to an identically structured database (using VBA), and then clear most fields displayed on the from to null. ie. Everytime the clear button is...
If the query is made from at least two tables, the displayed line may represent a combination of tables, and you will not be able to delete the line (since it is not a single record in a table).
It seems that you are filling a box behind??? My detail sections are not fixed heights, but grow or shrink depending on content. (as per line on page == details that fit on page) I tried it but got something weird.
I have a Detail section that I would like to alternate the background color when it is formated. (from gray to white so that this is used instead of putting a line between each detail) Can anyone suggest how to do VBA on the OnFormat section of the Detail. ie: Detail.BackColor = grey
I would...
Problem SOLVED! THANKS TO ALL, I actually found a Cacatenate function about three listings under mine on another persons question just after I sent mine. (The one dhookom sent me!)
Help! Is there something simple to do this. If I have a qry like this...
ID# Time
6 X
6 Y
6 z
7 g
7 b
8 e
how can I run a query/vba to get it grouped for my ID# so that it looks like this...
ID# Times
6 x,y,z
7 g,b
8 e
I am...
Need a little help remembering. I need to copy, rename and delete files in a folder on the network, from within Access using VBA linked to a button. I can't get the shell command to work! Can someone please provide a example of the syntax. Thanks in advance.
Easy question, but I can find it in the help files. I want to get the userID name retrieved from the network login. Is it something like???
Dim strUserIs as String
strUserIs = Environ("UserID")
Thanks in advance!
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.