Activity Stream

Thanks guys, i have this working by avoiding Const to Twips and using Long variables Dim lngOrg As Long, lngLarge As Long lngOrg = 2210 lngLarge...

I asked on another site about this and the answer I received was

Hi Bruce Can you upload a copy of your database?

Learn to use the query design grid. Then you would put the criteria on to different rows for each funcSysName. As mentioned, anytime you start...

4692*283 = 1,327,836 That still gives me error 6? Sub TestLong() Dim lngResult As Long Dim i1 As Integer, i2 As Integer i1 = 4692 i2 = 283...

Try setting lngLarge and lngOrgSize to CM instead of twips. Why is code choosing third tab page, but modifying the first page? Edit: Everyone is...

Why have a nested Select block when it only has one case? Your issue isn't obvious (at least to me). 4692*283 does not exceed the size of a long...

You should probably store those as child records of the original table. If you ever get a 4th or 6th Functional group you will have to rebuild every...

Doh! You're absolutely right. At 79 I'm having some difficulty reading the PDF image.

Not all B4-94 though Ken?

In that case I'd include the constant B4-94 in the divider when calling the Split function. You can see how it works in the immediate window: ...

I know, annoying as hell. :)

oops:) - problem with doing the from a phone with autocorrect

So I would use @CJ_London's logic, but loop from 1 and step 2 He also meant UBound, not unbound

You do this in vba dim a() as string dim i as integer a=split(fieldname," ") for i=0 to ubound (a) debug. Print a(i) ' do...

tHE 2ND OPTION, ACTUALLY ONLY WANT THE xxxxxx VALUES BUT I GET ALL AS PER YOUR 2ND OPTION EASY TO GET RID OF THE UNWANTED IS split () IS THAT THE...

What do you class as each text item? B4-94 xxxxxx or B4-94 xxxxxx I would use Split() with the relevant divider. That is up to you.

Well, give yourself a rise. :) It will serve you much better in the future. You now have ChatGPT and the like. You can Google and use YouTube....

VBA is above my pay grade, but I'll try the macro approach. Thank you! Thanks to everyone who contributed!

i don't use macros, too limiting - but if you are you can edit them. so for your missing query, choose the other one, then edit the macro I don't...

You could try the sql in VBA? I like @CJ_London can also see qry1 even after downloading the file again. Something screwy with your system. Try...

After doing a compact and repair and creating a new form, the result is the same. Strange. Is there a workaround to accomplish the following? delete...

works for me Suggest start again, create a new form

Welshgasman the query was originally created as you showed. It was changed to see if that would make a difference. The query works fine in either...

All you need for qry1 is DELETE tbl1.* FROM tbl1; You have WHERE in all the columns for the Delete row.?:confused: Despite that the query...

Here is db.

works for me as well - perhaps the delete query is wrong in some way