Activity Stream

I am having a problem with users closing Access by right clicking the Access icon in the taskbar and then closing it that way. I have some VBA in the...

Apologies in advance if my post title doesn't make sense. The issue at hand is, I have a tblBilling (image tblBilling) where some Bills have been...

Hi, I will start with some background. I have several linked tables that connect to a SQL server via an ODBC connection string. Upon opening the...

Private Sub GENERATE01_Click() On Error GoTo Err_GENERATE01_Click Stop Dim rs As DAO.Recordset SQL = "SELECT * FROM query1" ' ...

Greetings, I have a textbox where the user is required to enter either one of two words after placing a check in a checkbox. Those two words are...

Hi All, Good day to everyone. I hope you can help me with my issues with append criteria. Okay, i have this database that contains employee...

Back to my return log...the key on the main form is the RMA#. It is an autonumber and I have it formatted like "23-001", 23-002", etc. However a...

Is there anything structurally wrong with this DLOOKUP in a report field's control source? Can't figure out why I'm getting an #Error message. ...

Let's say some changes were made to forms that one wants to keep. Then some changes were made to the VBA code and saved. Then some more changes are...

Hi Guy's i have had a look at this one and trying to work the method I have a Combo value List Listing Is...

I have a text box that the user needs to type only the last 4 digits of the customer's SSN. I want the format to be: XXX-XX-1234 Not sure how I...

I am currently working on a database for tracking equipment and equipment maintenance and I am currently having some issues on a form. On a form...

Hi Guy's, i need a little help on this one please ? I have spent a while trying different things to make this work!!!! I am looping files to go...

I was recently hired (volunteer) as the IT person for an organization and was not shown how certain software was set up. One being Microsoft Access,...

hi, i have a file and to 'unlock' a sheet, i have a password as '123' but i need to hide this when typing in, or mask it when typing in the password...

I want the user to enter a URL that points to an image URL. (EG: http://myphoto.com/image.gif) but on my form, I want it to show the actual image....

I ran across several sites that propose this solution (mostly for Excel) to clear the immediate window: Application.SendKeys "^g ^a {DEL}" ...

I'm trying to clean up a Before Update event so it prompts the user whenever the record is left in a form. When I say "left" I mean go to another...

Hello everyone, just looking for advice, it has been about 15 years since I use access. I'm trying to make a database for my ebay store. I have a...

I have the below query as the control source for a command button to populate a table ~ basic stuff. DoCmd.RunSQL "INSERT INTO TblVehicleExpenses...

Hi everyone, I am encountering a blank query. I know some other people may have posted it too, but my problem doesn't look quite the same. It works...

I have an MS Access Db file, with linked tables in the same folder on a server. Record locking on. Normally the 1kb record locking file is closed...

Hi, Can someone help me add a line in this code to delete the current table records? I'm trying to delete the table records and then add new...

Hello guys, I have a question that perhaps someone here knows how to solve. Question: Is possible for me to multiply two tables together to get...

Hi Guys, I have a table with three fields: ID, Name, Mark i also have created the following Query which ranks students in the table based on Mark...

I started thinking how I'm going to port part of an old design to Access, which allows for more than one process to run in a "workspace". I'm not...

So here is the situation: At data input, I want the user to enter a URL for an image. That part is a piece of cake. However, on the form for...

I have an enquiry form with several sub forms. Each sub form is set a visible or not depending on the enquiry type selected in the main form. E.g....

Hey all, Hoping someone has insight into what is going on with the issue I'm facing. Problem I have a Python script that exports a report...

I have a temp database, a/k/a side database, that I use for temp tables. I was toying with the idea of deleting and re-creating the temp database...