Search results

Hi All, I am having trouble finding a solution to my problem on the internet. I need help moving all the data from the recordset to a table. I am good looping if it cant be done with with one command just keep in mind there are multiple columns and rows in my recordset. I also already have...

I have a database that runs everyday and does the exact thing everytime. It runs a query and exports a couple report to my C drive. I cant explain why sometimes it crashes when it gets to the export vba line and crash with a "Microsoft Access has stopped working". This issues does not happen all...

Hi everyone I have a statement which works fine if the value of the cell does not contain any special characters. The problem is if the value contains a ' symbol than it does not work. How can I work around this? DoCmd.RunSQL "UPDATE tbl_Audit_summary INNER JOIN tbl_area_list_tmp ON...

Hi guys I am having an issue with a database when creating a Oracle DSN. I am getting an error 3146 ODBC call failed. Source DAO.dbEngine This is only happening on 1 computer, I've tried on 9 others and they work fine, only this specific error on 1 computer. I have call a module to create the...

My goal is to close an already opened access database when Excel Opens. Before anyone asks why I am doing this, its because my excel file has a connection tied to this specific db that is opened. The connection data that my excel file contains does not refresh if the db that is trying to connect...

I have a sql to run and I have to use many values as parameters (over 1000), which is why I am trying to use a SQL inside a IN condition. I am testing the sql with only 1 value for now. The parameter I am using will be 2208287. This returns in a matter of seconds. Select a.po_id, a.sku12...

I have an option group, with of course the button where you select and beside that is the label name. On click this runs a query but my boss only wants it to run when you hit the actual select button and not the label name. how can I disable the label name or unreferenced this to the...

Good morning people, I have some reports that I run on a weekly basis and that I am trying to automate. I have a make table query that is tied to a SQL Query (which is on the code below). I was successful in changing the SQL Query code using VBA to my needs but I am not able to connect...

I am having trouble saving an outlook attachment to a folder using VBA. It was working before when I was saving it to a network drive folder but now I want it to save to my documents folder and I am getting an error that says: Run time error '-2147024891 (80070005)': Cannot save the attachment...

Hello guys I am having trouble with a If statement. I am trying to save a record into a table when an item is Selected (highlighted blue) in a list box. Keep in mind that my listbox is set to multiple selections. I have the following code but sometimes it works and sometimes it doest. Please...

Hi everyone Iam having a problem starting my database... I am trying to do some data entry using 2 tables in a form. Here is what I have: tableUser tableAudits formUser formAudits (set as datasheet view) My main form is formUser and I have added a subform linked to formAudits using ID field...