fdfjc
Last Activity: Feb 7 '11, 09:36 PM
Joined: May 26 '10
Location:
-
Thanks Stewart, it works! -
Populating Excel from Access
Hi, I have a problem that has been addressed here before, but I can't seem to make the answer work. I am populating an Excel spreadsheet from MS Access with the following code. It runs correctly the first time, then the second time, it gives the rt error 1004, Method 'Range' of object '_Global' failed. I know I need to fully qualify the range, but I'm having a hard time accomplishing that. Here is my code. Can anybody give me some advice? Thanks... -
I think this may be what you need. You can create multiple queries, building the second one based on the first one, the third one based on the second one, etc. in the following way.
The two lines I have commented out are the ones I use to make the query visible--the popup you are seeing and a msg box as a debugging breakpoint. I only use this during development and debugging -- then I comment it out. If you comment out DoCmd.OpenQuery ....,...Leave a comment:
-
I guess part of it depends also on the version of Access you are using. 2007 no longer has user-level security, so this has been my work-around, but I am dealing with only a few users. You could take that table with everyone's names and assign a permission level to each. For instance
NAME PERMISSIONS
Pam Company A
Greg Company A
Sam Company B
So when username is Pam or Greg, you...Leave a comment:
-
Hi Rhonda, Access makes it easy to do this in steps. In the first query you have figured the TimeElapsed. In the second query, you can use something like this: IIf([TimeElapsed] Between 29 And 59, 1 , 0) AS 30to60, IIf([TimeElapsed] Between 61 And 89, 1 , 0) AS 60to90 etc. Third query sums up each time period and gives you the total count. You call the last query in your code. I'm not great at explaining, so let me know if this isn't clear....Leave a comment:
-
Capture userid and enable/disable buttons
Hi newbornman, here's how I've handled this. On my main form (or switchboard) I capture the user's login and enable/disable, show/hide the boxes, forms and buttons I want each to have access to.
...Code:Dim usernm As String usernm = Environ("USERNAME") 'Debug.Print usernm If (usernm = "JohnSmith" Or usernm = "JoeSmith") ThenLeave a comment:
-
I found the answer in case anybody runs into this problem. I uninstalled and re-installed office 2007 and that fixed the problem.Leave a comment:
-
Subform stopped displaying data
I have a MS Access 2007 application that I have placed six subforms on to use as picklists. They are each populated from a table and are not linked by parent/child to the main form. They have been working all along until yesterday I noticed that none of the lists would display. I can open the subforms separately from the main form and the data is present and displayed correctly, but the data is not displayed when the subform opens in the main...
No activity results to display
Leave a comment: