Search results

Wow you took that in a completely different direction that I originally intended. I am an open source supporter and think that having a skilled programmer help you refine holes in your code will ultimately lead to better source code. I also have an analogy. Programming is like working on cars...

I would recommend just trying to build some things yourself. You will never learn this language simply by reading what someone else wrote. On a side note, lol @ your username root while trying to learn a Ms specific program.

Just change: Call Form_frmQuotesGenerator2.modFormCompletionCheck to this: Call modFormCompletionCheck ("SomeVariant")

It looks like there is a comma just before the where clause. Also there is no FROM.

If you would like to control the subform through a button click then yes use the button_click event. Then if you only want to change one control like chkBox2 then you don't need the loop. Just set chkBox2.value = true or false depending on what you want to do.

It's been a while but I think the Run as options are used when the screen is locked. So technically you are not "Logged In" in windows terms because the screen is locked.

I haven't scheduled anything for a long time due to a group policy setting that changes the reg entry for the security warnings, but I do remember trying to find a way around this and never did. I think that the windows scheduler is based strictly on each users profile. So if that user is not...

You should try to use breakpoints then. Click over on the left side of the code where the grey bar is and the line should turn red. Now when you run the code it will stop at that line. Once it is stopped just hover your mouse over the different variables to see what values they hold.

You don't really need VBA for this. Well mostly you don't. First create a query that orders the field and gets the "Last" of that field. Then create another append query that uses the first query's value + whatever increment to insert the next value into the table. In your form use the on load...

I'm with DCrake on what could possibly be the point of this? Saying that however, you could do a couple of things. One would be a hidden label/textbox that is updated each time the form is opened. Then add whatever than control's value is to a table. The other way would be to run a query that...

Are you just talking about using a scheduler to run the macro?

Beyond what HiTechCoach said I would also recommend removing the excel manipulation from access altogether. Access doesn't play nice with excel all the time. You will occasionally run into problems where Access can't find the handle for excel and then spits out some error indicating that the...

It might not understand where ![Field] is pointing to. add the object in front of the ! and it will probably work. Is this reading from a form or something? If so then just change it to me.Field.value, then test for null before proceeding.

It seemed to me that the OP wanted to manipulate the controls on a subform as the records changed. So I was saying that the controls could be changed based on some criteria as the records change. The question was really general so I gave a general type of answer.

I have never actually used this so I was just poking around with it. There a function that you can use to test called stillExecuting . this returns true if the connect has not finished. So you can loop while it tries. just a while db.stillexecuting ''Do nothing wend would work maybe.

You could loop through all of the controls something like: for each x in me.controls if isSomething(x) then ''Do something end if next

You didn't seem to include the replace within the loop. So it only gets updated one time before the loop. not at each record.

The DBQ is whatever is in the data source name field when you look at your driver in the ODBC manager. So when you go to the Administrative tools/ Data sources it is whatever is in the "Name" column. The SSD was something I forgot to take out; that is the name of the database that you want to...

Here is the best I could come up with. It builds the connection but it will still propt the login box if the uid or password are incorrect. Dim db As DAO.Connection Dim ws As Workspace Dim oracleConnect, redBrickConnect As String oracleConnect =...

I think that I may have misunderstood what you needed when I first read your post. Not sure exactly how but look into the opendatabase method in the help for an example of what to use.