Search results

He's tried printing on different printers and gets the same thing.

I have a report in a database I created that is being used across many different sites and has been for years. Recently one user reported to me that after a computer refresh (in our company that means getting a newer, updated computer), this one particular report looked/printed incorrect. The...

One other note. The menu used to show up for this individual as but suddenly stopped.

I have a database used by many different people where the front end resides on their PC and the back end resides on a shared drive. It has auto update functionality so the users always have the latest version of front end. This database has been in use for years and uses a custom menu bar. I...

Already did that and it still returns all of the records even with a value in the text box.

WHERE ((TRUTRACK_EMPLOYEE.DEPARTMENT) Like "*" & [Forms]![F_OT_Report]![txtDept] & "*")

I appreciate everyone's responses. Maybe I can clear something up. I placed a default value in the text box for a filter at open just as a test. I was trying to solve my issue and that was just something I tried to isolate the problem. Ultimately the filter (text box) will not be used until the...

One other bit of information. The text box is unbound if that makes any difference.

I have a form that obviously has an underlying query. One field of the query has a contraint based on a text box on the form using the Like command. When opening the form, it displays all of the records as if no entry was in the text box. The contraint does use wildcards so no value in the text...

Anyone come across this issue? We have a database we have been running in Access 2003 and it was working fine. We converted over to 2010 and now none of the modules will run - in a nutshell it says they're not there. When you go into the modules section you can clearly see them all listed but...

Yes it is. In fact, I even tried changing the choice to none, closing the database and then reassigning the form to open and it still won't.

The part of the startup sequence that it is skipping is the loading of a password form. The form should load and if the right password is not entered it closes the Db. Right now it's skipping the form and loading the Db anyway. As far as I know there haven't been any hardware changes and the...

OK..this one has me completely stumped. I have a Db that has been running fine for some time. Suddenly now it is bypassing the startup configuration altogether when it loads with the exception of the custom menu. There is not an autoexec macro so the issue isn't related to that. I'm pulling my...

Alright, this has got to be simple but my brain is so drained from the day I can't get it right. I need a vba formula to determine if the current date is after April 1 of the current year. My weary melon thanks you in advance.

Appreciate the suggestions. I'll give them a try. I'm curious though. Since this is only cropping up on a couple out of several computers/users, does this not point more to a settings issue at the references level or something similar?

I have created a Db used by a large number of folks in our office. I have recently been made aware that on a couple of the computers, they are getting the following error: Method 'CurrentDb' of object '_Application' failed It is in response to the code: Dim rstUserInfo As DAO.Recordset, sUser...

Dave, I did have an error but abandoned that method. The last posting shows my latest approach. This is what is in the text box. =Sum([Credit])-Sum([Debit]) This is what is in the afterupdate code Private Sub Form_AfterUpdate() If Me.txtBalance < 0 Then Me.lblBalanceDue.Visible = True Else...

Alright. I have this working .....sort of.....by using the after update trigger. The only problem is that it seems to lag by one update. In other words, on the first update it works fine. But any subsequent updates it seems to be one behind in its conditional fomatting. To put it more simply, if...

I tried the following code and am geting this error when opening the form: "You cancelled the previous operation. Private Sub Form_Current() If Nz((DSum("[Credit]", "Q_Account_History")) - (DSum("[Debit]", "Q_Account_History"))) < 0 Then Me.lblBalanceDue.Visible = True Else...

I was actually doing it in the control source of a textbox so that it automatically updates whenever a new record is entered. I hadn't been using DSum but now that I think about it I probably should (instead of the standard Sum). Would OnCurrent still work or would the control have to be...