Search results

I wasn't able to find a solution to my particular problem yet by searching so I am posting a new thread, apologies if this already exists elsewhere. About a week ago one of the computers in our office started getting an error message when trying to open any access .mdb file. The window title is...

I've got several access databases located on our file server. Numerous users throughout the office have access to open and view them as has been the case for several years. Since the beginning of the year we have started seeing a brand new issue occur every couple of months in a few of our...

Can't seem to find a solution to my problem here or in a few reference books I have on my shelf here at work. I inherited several access databases from my predecessor a while back and although I’ve fixed most of the pre-existing problems and re-programmed most of the queries and reports at this...

Unfortunately I'm a bit short on knowledge of VBA and only know enough to start being dangerous. I've spent 3 days researching these forums and several access programming books in an effort to solve my problem but have not been able to sucessfully apply code examples I've seen to my database. I...

In a recent performance review it was recomended that I keep learning new skills to improve my position in IT in the company I work for. In the weeks afterwards it's been heavily suggested I get very good at sql and sql server as we are trying to transition away from Access and go to a purely...

I've got a query pulling data from a view I created that gives all the data I need. The query gets it's criteria from a form with 10 combo boxes, a radio box with 3 options and 2 date fields for the timeframe to run the report in. The issue: over half the columns of data that the radio buttons...

I'm in the process of streamlining the process to maintain our various access reports and queries. My company's accounting software stores all record dates in Gregorian Serial format (don't ask me why). Currently for our reports we have a local hard-coded table that is manually updated...

ok, so I felt like being slightly poetic.. :D On to the problem. I have a form that's fairly complex and drives a report our sales and management departments use to determine a lot of business decisions. The form has a couple of date fileds and 10 combo boxes. Each combo box get's its list...

I've got a query that is defeating me, but that might be due to a week's worth of insomnia related sleep problems. My issue exists in the following query, of the four IIF statments in the HAVING portion of the query and the need to select all if the statement is false for each one of the four...

I have a database that suddenly has a new error this morning that might have been caused by another user while I was not in the database. When an event procedure is triggered by a form the following error is given, regardless of the code or the event that triggered it: "The expression on [event...

I've been building a report that has the option to export the report per employee into a seperate file and to add more functionality to it I found this sample database and used the directory select to allow the user to define where the reports export to. It works beautifully on my computer but...

I just inherited an old database report, I have a report that breaks down monthly sales for each of our vendors and starts a new page for each vendor. Currently it creates a report roughly 700-1000+ pages each month. In an effort to save paper and postage we are wanting to export a seperate file...