Search results

The control wasn't empty and the form was open but..... it worked!!! Yeh hey hey heyyyyy! Thank you! XXXXX Honest will try to figure out why so I do learn from it (I hope :-/)

but I'm still getting: You entered an expression that has no value.

Do you have "Option Explicit" set at the top of all your code modules? ...... I do now! RunType is the name of a text box on the form & I refer to it as =[Forms]![DownstairsOrders]![RunType] on the report.

Thank you Pat - makes sense & sorry for delayed response... Now getting Run-time error '2427': You entered an expression that has no value... I can see the value in the filtered report but I'm obviously missing something - Arrrgh

Sorry - should have added the report is called from a button with macro below...

The message box says "A custom macro" rather than code but when I take the code out the report generates fine...

Yes the code is in the detail section of the report in the On Format Event - so not exactly sure ... image might help?

Hi, I'm a coding absolute rookie and am trying to make 2 info fields visible/invisible depending on the value in a 3rd field. The code has compiled but it's not working - is there something else I need in there? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Text99 =...

Got it working :) !!!! Sorry for all the questions .... but it is great how formulating the questions often suggests the solutions. Wish I was a clearer thinker :-/

Have got the Order ID to the pop up by using Modal & Cycle Current Record with Default value on Order ID referencing the main form's Order ID... But get error show on pic when trying to save it.

Sorry to bug you again folks... Got the laptop/tablet (thanks isladogs!) and now trying to adapt the form (which now works fine (thanks all!) to the smaller screen size - image attached. Think pop up forms are the answer and the Add/Edit Customer one works fine but when I try to replace the...

👍Ta

Thank you :)

Sorry 🙄, yep if they can face the change & ha e the dosh 🤞

Yep - if there's Gulp! - Useful but might have to take a while to think it through... Thanks!

😅 S'okay for you pro's - I'm petrified to change anything in case I rock the boat! The types & sub types have no relationship in access but they do in the mind of the user...But I shouldn't mix the two up - My only excuse for bad practice - apologies Pat :)

I could maybe copy the DB onto a laptop and set up an export file to email/google docs that could be appended to the main DB? Might have to brush up on appending data or would a union query be less fraught?

You get the gist 😅 I'm Scottish!

Maybe I should post this bit as a new question but... This DB is used to gather Christmas order prep info & generate production crosstabs, route planning uploads, delivery schedules, labels etc for when there's a huge amount of product (for a small business) going out over a couple of days...

& crap naming of tables!