Recent content by Ceebee86

Hi, Isladogs was kind enough to point me to her updated code when I was having problems, yet I still am having issues and hoping its quick to fix. The code works in my query if I don't place a where clause, if I remove it, it works fine. I get error 3061. Too few parameters, expected 1. I...

Hi, I'm trying to get this to work in access 2016, and it goes straight to error. Run time error 91: Object variable or With block variable not set. I've tried with Option Compare Database, and Option Explicit, and get same error. I think it may be this line.. Serialize =...

That was my problem, I was trying to do a one regex fits all possible combinations with GS1 identifiers....but its not that simple, and Gasman's simple approach has helped me out immensely, had tunnel vision. :(

Thank you! This method works well for me :) I tried this on Sunday and it worked a charm. :) Thank you for digging me out of a rut!

Thanks, I'll give this a go tonight. :)

Hi, I'm quite new to access (4-5 months) and RegEx. I've searched the internet so much over past few days, tested with regex101.com and I can't get it right. I have a regex module which lets me use it in access as a function. I have a few suppliers, and their bar codes are all different...

When I use criteria 01/11/2019 - 13/11/2019 StrWhere = ([SCANINTIME] >= #11/01/2019#) AND ([SCANINTIME] <= #11/13/2019#) I get results. If I do 30/10/2019 - 06/11/2019 StrWhere = ([SCANINTIME] >= #11/01/2019#) AND ([SCANINTIME] <= #11/13/2019#) I do not get any results, blank page...

Forgot to mention, if I search 30/10/2019 - 01/11/2019. I get no results. If I search within the months, and not across them, I get results. Frustrating. :(

Hi Access world, I am using http://allenbrowne.com/ser-62.html tutorial to make a Filter for a form that's record source is a query. I have used the tutorial very well, up until the point I tried to do a Date search between two dates. Code: Private Sub cmdFilter_Click() 'Purpose: Build up...

Thanks for the replies. I do use quite a few functions in my select queries, I'll see if I can cut a few of these out. I imagine the data tables they are based on will get quite big in the future, the tables have about 5-10 columns in each table on average with the last query having around 30...

Hi Access world, I have a complicated query (well it is to me! :) ) that I have written with some help along the way. I want to stream line it, and I am quite new to access, been using it for about 3 months or so. It's purpose is to provide an overview of information in continuous forms, that...

Hey guys, Using CJ's and Arnel's suggestions. Have two tables for the barcodes, tblAGLGRN & tblAGLSSCC (populated with admCount values) Thanks for the idea's, I think I have got to a place I'm happy with now. :) So... route I found myself on was... Main form from a table for Barcode1 (...

Hi CJ, Sorry, I thought I was being clear, and having entered the access world, I have found its hard to describe things...perfectly. :( run 1 MZOUKBTY000001..416001 MZOUKBTY000001..416002 MZOUKBTY000001..416003 MZOUKBTY000001..416004 MZOUKBTY000001..416005 run 2 - same customer different...

Ok...so...I have got this to half work I think. Very cool code. I made the unbound form, and referenced the fields by name in the SQL you provided, and it came out with the below (pictures attached) Put in 20, it gave me 21. Edit: added +1 to the code. :) I need barcode1 to stay as...

Thank you for the help. I've looked at this previously, and have it saved somewhere, if everything else fails, I'll go back to it, as it was quite complex for me to understand, and didn't work as it was trying to access the creators file server I think...