Search results

You need to write some VBA code to delete the record in your onchange of the option group If me.optFunding = 0 THEN '(or whatever value your NO value is set to) Currentdb.execute("DELETE FROM tblFundingSources WHERE ID = " & MainFormID END IF YOu need to delete where the funding source record...

Okay...good luck with the rest of your project!

First thing I would do is create a table to store your kelly rotation data. TABLE: tblKellyRotation Fields: KellyRotationID autonumber primary key Day int, Week int Status RotationType int Create a record in this table for Every day and every status in the 4 week period. You will end up with...

Change acViewPreview to acViewNormal in your Docmd.OpenReport argument

You need to move the focus to another control before you hide the combo box. ControlName.SetFocus

No, but does your query behind Form B have a parameter in it? You should remove it if it does. Also, check Form B filter properties. Make sure there is nothing in the filter property in Form B

However you are running the report - whether it's from click event or module, just make sure you modify the querydef before each report print for each different auditID. It doesn't matter where the code resides. Hope it works. And, YES, I would keep a backup copy of the existing report. :)

Numerous ways to go about it. Are you comfortable using VBA?

Check Form B, when you open this form by itself from the navigation pane do you get prompted for the parameter? If not, then make sure Form B actually has a field in it called [Formatted Cost Code].

Is it possible for you to post your project? It seems like you have too many steps to accomplish what you are trying to do. I don't really think you need the global function.

That's not going to work unless you are printing directly to the printer. If user is going to preview the report you won't be able to loop through and preview the next report becuase the user will have the report open in preview mode. Also, if you do the loop and print directly to the...

You can try a few things: 1. Try re-linking the tables on that specific user machine. 2. Try to open the back-end from that user's machine and see if the tables can be added to directly? 3. Also, is this user on the same version of Access and Windows as others? 4.Is this a user specific or...

You know what, you probably had both text boxes (txtNewAddress and txtAddressSelected) bound to the same function. I bet that's what the issue was. So you say the address boxes flickered, if they both had the same function than when you requeried txtAddressSelected you ended up kicking off an...

What line of code are you getting the error on? Error 91 is Object not set to an instance of an object, so it might be wherever you are setting your Excel objects. Try changing the code where you open excel to this: On Error Resume Next Set objXLTemp = GetObject(, "Excel.Application") If...

I would remove your code from the OnActivate event of the report. Put it in the button you use to run the report and then instead of relying on passing the where clause to the SQL Statement - create another query called qryauditresultsReport with the following Syntax: Select * from...

I think you need to go to External Data>Saved Imports. For system tables you need to right click the navigation pane and go to Navigation Options. See attached.

So there is a checkbox that gets checked for each record that is being printed? In that case you have to loop through each record selected and evaluate each one separately. Also, between each record you will have to close the report and re-open it for every record. Something like this: Dim...

I believe the issue is that your txtAddressSelected has a control source that is your function looking for the address in the currently selected record. You can't set txtAddressSelected to any other value because the function will continue to run and look for the value in the currently selected...

If I understand your need, you want to generate a record for each day of the year (365 days) for each new employee and based on whether the kelly schedule is schedule 1 or schedule 2, you want the work status to say Working or Off based on this? So ideally, you would end up with a table like...

Check your raw table data. The entries put in earlier in the DB may have the space hard coded in it, while the others may store the data without the space.