Search results

Thank you both. Ended up using part of June7's response. Set rcs = cmd.Execute If rcs.EOF Then 'Do nothing if no data returns. This is handled outside... after this module runs. Else rcs.MoveFirst Do Until rcs.EOF = True DoCmd.RunSQL "insert...

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

Hi Doc, I have also tried to open the report manually and sometimes it crashes. Funny thing is, it might open good one time but if I try again it crashes and I get the same message. It happens on and off, frustrating. The database is only 3 MB. The database has compact on close and I have also...

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

Issue was due to the Where condition. I only had where field is null but forgot to include, or field = ''.

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

That's a pretty good explanation, I guess I still have a lot to learn. thanks Doc

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

Where will I place the inner join? I haven't really used this

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

Ok lets go back and make it easier. I say just keep the text box and add a button on the side. me.lstitems.requery Add this code to your button on event On click. This should do the trick. The list will update only when the user clicks on the button.

yes add that below your refresh list code to see it it works after each letter you type on the text box

Np, I mean Refresh the form. me.form_name.requery

Try: me.form.requery

You have to do a On change event on your textbox. add this code on that event list_name.Requery

1. Create a text box to use as your filter 2. Open your query that is tied to your list box. 3. Tie the field to your text box which will act like a filter... Like [Forms]![form_name]![text_box_name] & "*" 4. Go back to your text box and add code On Change event or After Update. 5. On your...

Thank you guys for the info. I actually didn't find anything on the web so I decided to try this.

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

This will remove a day from today and from there you can do whatever you need to do. variable= DateAdd("d", -1, Date) if variable = (bankholiday date) then 'code here else 'code here end if