Search results

Zip file included.

Hi, I have compressed the BE and FE into one .rar file, then change the name to .zip and attached it here. You can reverse that if you would like to review them.

I have a Summary Report in Access 2019, running on a high-powered PC with Windows 10 Pro and all updates. It is based on a Summary Query, which in turn, is based on a “Base” Query. The report runs fast and fine as a regular report, but when I change to Print Preview, or try to print on paper...

Yes, DBguy! That did it! Thanks so much!

Doc_man, I have seen many of your very educated responses to people, so I know you know what you are talking about. I'm not nearly as advanced with Access, so would you be willing to modify my code to allow me to accomplish my goal. Originally I wanted to have a dedicated field on the form...

thanks to all for your attempts to help. I am an experienced access programmer but certainly not an expert and am unfamiliar with advanced programming such as this. I tried to copy this code and modify it from some other forums, but obviously, I am doing it slightly wrong. I have a standard...

thanks for the reply. i put a msgbox(err.number) in the code and can see error 91 is being set on form load. research is telling me the i have some Declaration statements maybe set wrong? Is there anything else I can tell or show you that might make it easier for you to help me with this...

I have the code below that is supposed to check if a record is locked by any other user, and if so, pop up a warning message. The oncurrent event runs this single line: DisplayLockStatus. It seems to work fine when User1 is in a record and User2 tries to view that same record, but the...

Very nice! How did you figure that out? Or are you just extremely intelligent! Either way, I THANK YOU so much and Im very glad to learn it is something as simple as that! I have just advanced my knowledge thanks to you! Enjoy your day!

Very strange. i have an Access 2019 report that opens just fine and filters and prints fine and closes fine, but if I open it and then the very first action is to hit the Tab Key on my KB, it crashes Access. Using Windows 10 Pro with all updates and Access 2019 and the same issue occurs on all...

I have whittled down my db to just the pertinent info to send to you to show what my goal is, but its still 10meg front end and 30meg backend. do you have a dropbox i could send it to? or maybe i can share it on my google drive and you can download from there? heading to sleep now. more...

the filter add was just an example. adding the filter is easy and it shows up in the filter properties box by design. for some reason, recordsource is different and it does not show up. do you know what I mean by showing up in the properties box?

yes, that overrun of code was what i was running into before I solicited help on the forum. Im not sure where the code control transfers and if there would be errors as a result. I have tested it briefly and it appears to work, but Im not skilled enough to really KNOW. I have never used...

ok. i will get back with you. thanks again!

yep. i see it working. and its doing that on my end. but i need it to not close. let me play a bit and send you a better sample of what im trying to do. Im in chicago, USA, where are you?

let me send you a new file that shows what Im looking to do. it will take me a while to prepare the file. thanks again. jm

im using 2019 access on win 10 pro. can you try this file and see if i have something wrong? I would be happy to show you what im looking to do , but it a huge db, so i would need to remove all kinds of stuff first to make it smaller and remove the customer sensative info. i can do that if...

this is my vba. do i have something incorrect: Option Compare Database Private Sub Command2_Click() Me.RecordSource = "QueryRed" DoCmd.Close DoCmd.OpenReport "report1", acViewDesign Reports!report1.RecordSource = "QueryRed" DoCmd.Save DoCmd.Close End Sub Private Sub...

i tried the code but as I suspected, the 2nd line: DoCmd.Close seems to terminate the vba. were you able to make it work in my sample?

hi, thanks for the quick reply! the attaches screenshots are what I am trying to achieve. Similar to if i used me.filter="test" instead of me.recordsource = "Blue". does that help you understand my issue? Thanks for the help! jm