Recent content by quiksilver1804

You forgot rs.Update rs.Close Try that!

I have a form with multiple filters and they are applied by a "Filter records" button. One of the filter's is for a name of a company. The problem i have is it does a wildcard search automatically. IE: "Starbucks" is entered will actually do a filter of Starbucks* The reason for that is...

Not sure if this will work or not because i'm not sure of the rights situation. But the best thing to try and do is when you click the button to open up your form, go to the code behind (button.click) and put in "DoCmd.Close" which will close the main form you are on (which closes the query)...

I'm not sure why the data goes away. Do you close the form and go back to it? If you are hitting a save button to save the data, then i think the best way to pull the information is doing a Dlookup(). If you are unfamiliar with it, go here for syntax...

I never use DAP or haven't got into it yet.. but if there is anything i know about access is that it's Random :) The DAP could be corrupted, did you try rebuilding it on a new one? Like i said, i never use DAP and don't know how hard that would before you to do. I just know some vba code won't...

Well if the data entry form is based off of a table, turn it into a query. Drop down all the fields (individually, double clicking the title will highlight all fields, then just pull them all down). In the "Criteria" section put: [Enter Project Name] in the Criteria: for the project name field...

Good morning. I've never really imported excel into a report for any real purpose. 99% of the time i just design my report from scratch. I tested the idea though and when i opened up my excel sheet, i used the cursor to highlight the area that i wanted to insert into Access, copied it, and just...

I have a continuous form and want to display 6 buttons. I want the buttons to display depending on if there is a value in a certain field or not.. fields "DocNum1" thru "DocNum6" from TCD_RequestedCRDB I was told that the Visible property doesn't work for individual records on continuous forms...