Search results

Thanks, Isskint, I got it. I went back and rebuilt the whole search form from the beginning. I must have changed a property that I shouldn't have. Anyway, when I created a fresh new form, everything was working again. I gave up on the query idea and just built a more complex filter. I was...

Hi Experts, I created a search form. It has 6 unbound text boxes and 2 combo boxes in the header. Users can select values from the combo boxes and/or enter names in the other text boxes. These values all go into a filter on my Main table and the filtered results show up in the detail section...

Mischa, The first thing that jumps out at me is ActionID. Is that a Primary Key or required field? If so, you won't be able to change it to null. Second thing, and probably the problem, your EXECUTE statement needs a semicolon at the end. Try this:myDb.Execute "UPDATE tblSubComponent Set...

Thanks Spike & Mihail, I got this resolved. I had 2 problems. 1) I was able to set the UNC path in the Linked Table Manager. 2) .Seek is for use with local tables, not linked tables. I had to use .FindFirst instead. Thank you!

JPed, I have handled this issue in a couple of ways. 1) Make the Submit button invisible until data exist in all the required fields. This requires more programming, but may be necessary for some customers. 2) When the Submit button is clicked, go through a check of each required field and if...

OMG!:eek: I had no idea! I was using the list from the MSDN website. I have gotten so much good stuff from Allen's website. I don't need to copy his functions whole, but I do read through them, comparing, to see if he did anything different than mine. I usually find that he's much smarter...

Carl, Don't want to make a big deal about it, (I'm fairly new here too) but it would help you to put a better title or subject line when you post a question. A good title will attract experts who know about that topic. Again, not a big deal, but just want to help you get more/better responses to...

Is there a way to mark these threads as "Resolved"? Just want to let you all know (from the OP) that this is resolved and in case any newbies find this thread in the future, here is what I did. The best advice was from Bob, Although the users have different drive mappings for the back end...

-- Off Topic -- :rolleyes: Thanks, Paul. I've been bitten by reserved words, even recently! We know that "CurrentUser" is a reserved word. Right? So, I tried using "Current_User". Turns out, that is reserved too! (by the Access database engine) Had to go with "CurrUser".

JPed, My first question goes back to how you are using this on the form. It sounds like you are accepting an entry in an unbound text box, want to convert it to the proper format, and then compare it with data in a table. Maybe query the table or something, right? If it's an unbound control...

abzalali, If you want to hide the nav pane from the users when they open the application, put it in the AutoExec macro. I do this for just about everything I create. First, create an AutoExec() function in your Module1. In this function, you put all the VBA code that you want to happen when...

Pete, I tried the code you put in the first hidden.zip file. I'm using Access 2007 so it was converted to a .accdb file. When I ran mcrHide, it minimized the Access application to an icon on the taskbar. That's fine except my users will try to restore it from there. So I tried the "Hide" code...

Bill, I tested this. I'm using Access 2007 and when I look at a form in design view, I open the property sheet to the Other tab. Shortcut Menu is about halfway down the list. When I set it to Yes, the right click shortcut menu works on the form. When I set it to No, the right click shortcut...

Paul, I think you're right. He wouldn't be able to set the DataEntry property on the subform control on the main form. But he would be able to do it on the form contained within that subform control. Very good insight! I didn't think of that. Looking at the names, that must be what it is. I...

Allan, Data Entry is a form property, not a control property. From your code, it looks like "EditJournalFrm" is your form. On this form, you have controls named DocDate, KdVoucher, To, From, HeaderNote, InternalReff, Source, Posted, and EditJournalDetail. You've locked each of those controls...

Users have a Report Menu form with a dozen buttons on it. They push the button for the report they want. Embedded Macro behind the On Click event has 4 actions . Turn Warnings Off . OpenQuery runs a make table query . OpenReport opens a report bound to that table . Turn Warnings On It's pretty...

O.K. I have a solution. The code from EternalMyrtle works. I put this in as a condition for the OpenQuery action in my macro: CurrentProject.AllReports("Qtrly Sales").IsLoaded = False If the report is not open, the query runs, and there is no locking error. The next line of my macro is an...

Wow. Thank you. All good answers. I like the modal idea. The automatic close is good too. But I know that the users will insist that they need to have two (or more) reports open at a time so that they can go back and forth to make comparisons. I think I can make my forms modal to prevent them...

My users are clever enough to find problems that I'm not smart enough to solve. I'm using Access 2007. My macro runs a query and opens a report. If the user closes the report and goes back to the form, they can choose a different report, and everything works fine. However, my users will open...

I have solved this. I have a similar situation except working with Region, Area and Facility. I have a Location table (tblLocation) that contains 3 columns: Region, Area, and Facility. The combo box for Region uses this for the Row Source: SELECT DISTINCT tblLocation.Region FROM tblLocation...