Search results

Kyoch, I found another challenge similar to the first one you mentioned. When the computer goes to sleep/hibernates, this seems to suspend time too. As for your second challenge, I think the issue can be narrowed down to this code line:If (PrevControlName = "") Or (PrevFormName = "") _ Or...

Hi Dave, The user level security wizard went away in A2007, so you must have an older version. I didn't do much work in A2003, but can you try using the user level security wizard to remove the security? Or, go to User and Group Accounts to change the password to "". Remember that there are...

Thanks, Spike & Dave. With the current project, I'd estimate that these queries will run daily, maybe dozens, possibly over a hundred times per day. The database isn't loaded full of data yet, only 100 test cases. Testing won't tell me much right now. I'm sure the system will run a little...

Hi Bart, If you have it set up correctly, then any new records that you add in the subform should simultaneously be added to the table (Record Source) that is connected to that subform. It's no different from if it were a main form. Are there any required fields that don't exist on the form...

Hi Corey, Just a little advice to help you get quicker answers. Please try to make your message title as descriptive as possible. Most of the old hands on these forums will pass over posts with titles like "Please help". There are people who are real pros at forms and there are people who love...

Right. I should have been more clear. I am talking about action queries. What I do most often is pull a subset out of the back end database into a temp table for the user to work with locally. The users also send their adds and updates to the back end database. An example of my dilemma is in...

I usually execute an update query behind the button. It would look somethng like this: Dim strSQL As String Dim db As Database Set db = CurrentDb strSQL = "UPDATE tblTableName " & _ "SET [tblTableName].Assigned = " & Me.Combo55.Value & ";" db.Execute (strSQL) I know this...

Hi Experts, I don't have a problem, but am just seeking advice. Usually in my VBA procedures, when I need to run a query, I build an SQL string and then do a db.Execute (strSQL)This allows me to put in variables into my query string. You all know that. This usually involves declaring the...

[SOLVED] INSERT INTO SELECT statement Aaagh! JD, You are right. I was wrong when I said that the SQL ran fine because I forgot that I added the "Investigator" condition. So, after adding your line with the IIF statement AND adding double quotes around ""Investigator"", now it runs fine...

JD, Thanks for the advice. I had the quotes at the beginning of every line in my string. I don't know how it got dropped when I pasted it into a CODE box. I know the whole string is good except the IIF part. If I remove this "IIf(IsNull([M_Name]),"" "","" "" & [M_Name] & "" "") &" then the...

Hi John, Paul is right. You do not need to SET every field in your target record. You are using the RecordUpdate field in your WHERE clause. So just try leaving it out of the SET clause, like this:CurrentDb.Execute "UPDATE QryIssueData " & _ " SET IssueDate ='" & Me.txtIssueDate & "'" & _ "...

[SOLVED] INSERT INTO SELECT statement Hello Experts, Here's my challenge. I have an append query that contains an IIF statement. I want to code that into a VBA function. The SQL view of the query looks like this:INSERT INTO tmpAvailInv ( NUID, Inv_Name, F_Name, M_Name, L_Name, Role ) SELECT...

Not necessary. I made the enabled field 0.001" x 0.001" and put it on the far right edge of the form. With Transparent border & background, they'll never find it. If they do, they'll just think that their mouse missed the form and click again.

Kajtam, Look at this thread. Post #13 looks like the best solution for your issue. http://www.access-programmers.co.uk/forums/showthread.php?t=173222 HTH _________________ Regards, Marvin M Windows 7 Professional, MS Access 2007/2010 Windows 8 Professional, MS Access 2013...

Simon, You are a genius! I tried enabling the Record Number and found that the user could click anywhere on the row and the selection would change to that row. However, when clicking on that enabled control, the On Click procedure wouldn't fire. I can get around that very easily by just...

Simon, I'll give it a try. Thanks.

I want the record selector to go to the row that the user clicks on. Say the user searches for "Smith" and 5 filtered results show up. They can look at the 5 rows and decide, "I want to see John Smith's record." If they click on that row, it could be row #3, I want that record to be selected...

pwalter, Here's a great sample of a search form: http://allenbrowne.com/ser-62.html I use Allen's method of building a WHERE clause whenever I create a search, or a parameterized query for a report.

[SOLVED] Select a Record on a Search Form Hello again, Experts, Attached is a snippet from my search form. I have a search on Last Name, and in this example, I use Last Name beginning with "m". That pulls up two matching, filtered results, Mickey and Mimi. All the controls in the detail...

Harry, Yes! You can do either. Which do you prefer? Let's start with hiding them. Open your report in design view. Highlight your headers. They are probably all in line, so you can put your cursor on the left side ruler, and it will turn into an arrow pointing to the right. Click and it...