Search results

CurrentDb.Execute _ "CREATE TABLE tblUserLog " & _ "(tblUserLogPK Integer PRIMARY KEY AUTOINCREMENT, " & _ "TimeStamp DATETIME, Username CHAR);"

Thanks! I'm just OCD like that.:D Reddick-Gray is where it's at! Steindi: That's what I get for trying to be all fancy with the CREATE TABLE query.... try this: Private Sub txtPassword_AfterUpdate() 'Check that EE is selected If IsNull(Me.cboUser) Then MsgBox "Veldu nafn...

Give this a go... It's untested, but should take care of what you need. Private Sub txtPassword_AfterUpdate() 'Check that EE is selected If IsNull(Me.cboUser) Then MsgBox "Veldu nafn af listanum", vbCritical Me.cboUser.SetFocus Else 'Check for correct...

can you post your code?

I tried to copy into new db, but I must have left autonaming on when I did because now they are gone. I wish M$ would just disable the darn thing altogether. So that's the good news. The bad news is that my hunch was wrong. Still slow....:cool: -Definetely compacted...I've gone as far as...

From where is the logon screen derived? Is it 2003 and below user level access, one that has been developed, or windows username? Either way, I think using the currentdb.execute function with an append query (INSERT INTO) would do the trick here. The property/variable/function feeding the...

Hello, I have a db that is having some strange speed issues on some very basic queries. Objects that have a rowsource/recordsource with a SQL statment in particular are really slow to populate. Likewise on deactivate/activate the report query seems to reload. I've put breakpoints in every...

Hey guys, In my report's detail section, I need to display footnote references for each detail record that correspond to a footnote below. The report's purpose is to display records from imported transactions in two tables from two different systems, and display the difference. The report...

Sorry for the late reply, for some reason this was sent to my junk folder :confused: The Option Explicit shouldn't be within the procedure (between Sub/End Sub or Function/End Function) but inside the Declarations section (Very Top) of the module. I generally make if my first line on every...

What is the name of your text box control? Try this in the meantime: Dim EncNbr As String Option Explicit Dim EncNbr As String EncNbr = Me.EncounterNbr With CodeContextObject DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE dbo_Providers SET dbo_Providers.DateEmailed = " & Now & _...

Re: NT Command Script and Documented Steps to Decompile / Compact / Compile an Access Hey Michael, This script has saved us many headaches! Having said that, I don't think it's running the full process. The reason I say that is because when I run it, %DBfilesizepre% and %DBfilesizepost% do...

Not really sure how your procedure is updating the text boxes, but if it's a single procedure, you could put that procedure in a class module, declare the class as a module level variable of the form with events and create a custom event after writing to the text box.

You had me thinking I was dreaming error messages for a minute there... :o I substituted the code, and it worked fine. But then it finally dawned on me: It was how I was opening the report. Not sure how this will work with a form, but try replacing: DoCmd.OpenForm FormName:=strDocName with...

No unfortunately, because frmCalendar writes to a report's textbox control which can't be modified in the open event since the textbox isn't opened yet. Bummer, huh? That's why I want to go with the variable pointer method on frmCalendar, so that I can add it.... wherever I want!!! <evil...

Although I try to avoid API calls as much as possible, Access won't allow the close method during the load event, so I have my hands tied. Edit: In addition, the choose procedure that I'm running makes a call to a calendar form borrowed from Allen Browne that I tweaked which sets the date to a...

Wow! it didn't completely fix the problem, but my db is running MUCH faster! 21 MB to 14 MBs, that's incredible! The Paint is much smoother now though, to the point that I don't even think I will need the hourglass. Now if you'll excuse me, I have a few more db's I need to run this on! :D

By the way, here's what's in the code: '**************************************************************************************** '* '* Monthly Summary Report '* '**************************************************************************************** Option Explicit Private Declare Function...

UPDATE: It does fire the Detail_Paint event, but how do I know when the report is finished repainting? --------- That is odd, because they didn't omit it for forms... But yes, I'm stepping through it f8 by f8 and it's definitely not in load or open. What is weird is when I go into another...

That's what's throwing me off. The Open and Load events are completed when this is happening.

I have a report that I'm running in report view. When I open it, it will open the detail sans one column (uses a VB UDF). Then it wipes that. Then loads the detail followed by the UDF column it initially left out. Then it moves to the footer......and it seems like it is going through this...