Search results

Ok, got it! Thank you so much!!!

I tried that but now nothing happens :(

Hello, I have been trying to write some code to be used when my forms close. The code checks if other forms are loaded and, if not, opens the switchboard. My problem is that the switchboard is opening all the time. I am hoping it will be an easy fix for someone with more experience. Here...

So, you have the main form (switchboard) as the form and in the OnLoad event for the form you put in the code to open the report, correct? Is the report set to pop up and modal in the properties > other tab?

Ok, I figured it out. Just need an Exit Sub before the error handler. Thanks for your help.

JDraw: Can you please help me with my error handling? I am using this code but even if my search term does not result in an error, the message box appears: Private Sub SearchTxt_AfterUpdate() 'Set recordsource and perform search Me.RecordSource = "qryCompanies" On Error GoTo ErrHandler...

Sorry, this lead me to believe it was a combo box: For yes/no (i.e. checkbox field) you need to use -1 (yes) or 0 (no) or true /false.

That works for me but my users will not remember this. I guess I can put in an error handler that instructs them to use double apostrophes or something. That would be a solution if I cannot make it work perfectly.

Hello I am using the following code to filter my form with a search box: Me.RecordSource = "qryCompanies" Me.Filter = "CompanyName Like '*" & Me.SearchTxt & "*' Or webpage Like '*" & Me.SearchTxt & "*' Or PriorName Like '*" & Me.SearchTxt & "*'" Me.FilterOn = True 'Show message box if no...

It is going to be a lot harder for me to be active in this forum because I have been moved to the "hot seat" at work :eek: but I took a quick look and saw some problems: 1. Your purchase form is set to data entry so no records are showing up 2. Your linked child field in the subform is...

This is not really a report issue but a structure issue. You should probably disregard my first post and adopt the strategy outlined in the second post.

Another thing I was just thinking is that part of the problem may be your structure. If your tables are set up well, then you can achieve something like this without code. You could create a junction table (one to many) between the contacts table and the date and notes info that you want to...

One suggestion would be to set up an audit system and just use it on the one field you need to keep track of (in the BeforeUpdate event of the control use code to call the function TrackChanges). I used this one as a guideline. With a little customization it worked well for me...

I have found that you have to change it in the normal form view, which has its flaws. If you change it there and then save and close it will open up to the last setting. This is why I usually use continuous forms instead of datasheet. You cannot wrap text in a datasheet unless you make the row...

Yeah, no problem. Spikepl's solution is obviously the better one.

How can it be a lookup of a control on another form? It should have a table or a query as its recordsource. Can you show me table structure for the relevant tables?

Ok, good. Handling the wage increases should probably be a separate question.

I am not 100% sure I understand this but from your description it sounds like your table structure is way off. You should NOT have 240 fields each with a different part number. Have one field called part number in a parts table. Then you will have no problem sorting

is the material request control a lookup? If so, you can set the row source to include the status column. Then you can make a hidden calculated control that shows the status on frmHandledBy (=[MaterialRequestControlName].[Column](#) . Then you can use simple code in the form's OnCurrent...

It won't work if the forms aren't both open at once. That is much more complicated.