Search results

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...

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...

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...

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.

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...

OK Access wizards, I need your help. I have a form that sums the fields in the form (in the footer obviously). Also in the footer I have a label control that I want visible or invisible based on whether the sum is positive or negative. I'm having trouble with where to put the 'trigger' to get it...

OK. This may be a no-brainer and if it is then perhaps that would explain the state I'm in. I know you can launch MS Word from Access but is there a way to launch a non-specific word processor? In other words, perhaps utilize the user's associations in Windows to lauch whatever their word...

Is it possible to invoke the Printer Dialog box to print a report without ever actually opening the report? For example, DoCmd.OpenReport acNormal sends the report directly to the printer presumably without opening it (if it does open, it's too quick to see). I want the same functionality but...

I have a continuous form that after selecting a group from a combo box, should give the user the option to print a report associated with the selected records. The user chooses which to print from the displayed records by simply checking on a yes/no checkbox for each record. The print button...

Can anyone tell me why none of my lnked tables are showing up in the linked table manager screen? The database functions fine but I need to change the location of the back end and can't get the tables to show up in the linked table screen. Help!!!!!

OK I'm throwing a challenge out there to everyone. I am overloaded and trying to figure this out is driving me nuts. What I have is a table with a list of names as such: James Smith Susan E Jones Gary Duane Thompson etc. etc. Note the variability in how much of the name is given. What I need...

I've created a database for a group and they have requested that in one of the data entry forms (a continuous form) that they enter the data vertically instead of horizontally. What I mean by this is they want to jump from one record to the next but within the same field as they enter data. I...

I have a kind of peculiar sequencing issue with a query. I have several machine designations: A1 A2 A3 .... A10 A11 A13 B1 B2 etc. but the last group is designated as right or left...in other words C1R C1L C2R C2L ... I am trying to get the query to put them in order such that they appear...

I have searched the forums and I know that you can backup data in Access to Excel or another database. What I was wondering was if there was some way to backup your data to a backup file that you could import into another copy of the database on another computer (not on network). What are the...

This probably has a simple answer and I've looked through the forum to no avail but...... does anyone have a snippet of code that checks for the presence of a file? Thanks in advance.

I built my wife a database to use for her work that has worked fine for a good while now. Just yesterday, one of the make table queries began to act peculiar. Suddenly, whenever you try to run it it gives the following error: "The Microsoft Jet database engine has stopped the process because...

I am trying to send out an eMail and attachment through Notes and when I used this code the first few times it worked. Now it keeps indicating that there isn't a session running when there is. I even checked to see if it was getting a value for UserName and MailDBName and it is. When I try the...

OK. I've looked around and the only suggested idea close to this didn't even remotely work. What I want to do is take the string of a month, (i.e. Jan or January) and convert it to a day (any day) in the month so I can calculate days in the month. I know how to calculate days in the month but...