Search results

Hi Pat, Thanks for the input, I appreciate all the help I can get these days. Always learning something new!

Hi Pat, The gotorecord is because there could be several records displayed but the last one is where I want to land first. There's only 1 button, 3 IF's, each IF has its own solution - how would you do that less obfuscated? Please share.

I've got it working with Where now, thanks for your help Pat! BT100: stDocName = "RMA Data" strWhere = "[Serial Number]=" & strSN DoCmd.OpenForm stDocName, , , strWhere DoCmd.GoToRecord , , acLast Exit Sub BT200: stDocName = "RMABT200form" strWhere = "[SN]=" & strSN...

Is this Where argument syntax correct? strWhere = "Forms![RMA Data]![Serial Number] Like" & "'" & Me.wstSN & "*" & "'"

Okay I'll give this a try. I'm still curious though why the identical Call function is working on 2 other forms no problem but returning an error on this form.

Thanks Pat, I'm definitely a hack. Is it possible to use a Where argument to filter a Continuous form? I would definitely prefer to use this method I just didn't know if it would work.

Yes, I changed the Click events on these forms to Public: The code for all 3 forms is basically identical. The below code runs fine when run from the RMA Data form. Public Sub Command40_Click() On Error GoTo ExitError '-- Find Serial Numbers starting with --- Me.Filter = "[Serial...

I have a form (form1) which will open another form (form2) and apply a filter using a filter button already on form 2. I have applied the following code which works properly for 2 of the 3 forms this needs to be done on: The below line 'Call Forms.[RMA Data].Command40_Click' works for both...

I have solved my problem, just thought I'd share: I downloaded the Windows Process Monitor tool to see what was happening in the 5-10 minute hang time. Turns out one of the text boxes in my report was linked to a mapped network drive that we no longer use and it got turned off over the weekend...

Hello, I am seeing a very bizarre problem with exporting a report to PDF. When clicking to save the report as PDF, it is hanging up for about 5-10 minutes before completing, it usually only takes 3-5 seconds. This is only happening on one report in my database, other reports export as PDF no...

Yes this is multi-user with front and backend split. I'll stick with the global refresh it seems to work well. Thanks for your help!

Here is a screenshot of my form in Design View.

Yes I meant to say bound. I'm curious why I need to refresh then...

Yes I just checked out your video, I am using the identical NZ([Text0],0) equation in an unbound textbox, but my entry textboxes are controlled where yours are unbound, maybe this is the difference?

This works perfectly: In design view select all textboxes. In the after update event put in =Refresh Without the refresh, the unbound textboxes with the total don't update at all unless I close and re-open the form, I'm clearly missing something here? D

The total is located at the bottom of each column in an unbound textbox, but unless a refresh is done the total isn't updated. I'd like it updated in real time as soon as the user enters their hours. I'm sure I could be doing a lot differently, but if there's a possible way to do this that...

Hello, I am creating a Timesheet/Payroll database, on the main timesheet form there are about 100 text boxes where the user can enter their hours (10 days in the pay period x 10 different possible tasks. In order to update the total hours immediately, I require the following for each textbox...

Beetle, Worked like a charm, thank you very much!

I don't think they are the same. If the user wants to see what falls into FilterA, then they decide they want to narrow the search down even further, so they use FilterB, the result should show both FilterA and FilterB combined, but when I use FilterA, then decide to use use FilterB, it only...

Thanks for the quick reply! The problem is I don't want to run both filters at the same time. For example, the user filters by Product first, now they want to filter it even further with one of the other optional filters in the header... Do you have to include the previous filter in the most...