Search results

I have a really hard time sometimes figuring out why code that has worked for years suddenly stops working for apparently fundamental reasons without my making any changes to the database. For this one, I have a form code that essentially copies table data from one database to another while...

I have an unbound form with unbound lookup boxes looking up from several tables/queries. The lookup functions are correctly returning a visible in my list boxes, but I can't seem to grab that list box values to use in my code unless I select the list box with the mouse. Selecting in either of...

I wanted to view & develop my longterm db in dark mode to save my poor, abused eyes, but not all of my team feels that way. I carefully changed all of my colors to System colors, thinking it would match the user's system. However, now that I've deployed my latest beta, they all have dark mode...

Anybody good with writing search terms that would find all of my debug.prints that are not commented out? I'm not ready to remove them, I just want to know they aren't there sending secret messages in the background of my compiled program...

I need to output a text CSV file with a consistent table format to another program. This table contains a page number column and must contain a sequential numbering column. I currently generate a row number using method #3 from Access Experts...

General looping efficiency question for building a collection of controls; Do you think I'd be more efficient evaluating all of the property tags that I want to add to a collection before moving to the next collection, or would it be more efficient evaluating each tag & adding it to all of the...

Hi all, I'm working on import and update queries to bring data from an older format database to a newer, better model. There were a few things about the original that made it not perfectly normalized, so I'm addressing that in my latest version. Most of my update queries have worked, but one is...

Okay, I know all of the reasons one should not use a multi-value field, and I'm ready to admit defeat. However, I can't for the life of me figure out why this didn't work: I'm working on Update queries for merging old database records into my new format. I have one field in the whole dang...

I didn't see a PANIC forum, so hopefully "General" is the appropriate place for this. Was working on my project yesterday & had a snafu with a tech who was mucking around in my "WORKING_DONT_TOUCH" folder while I had things open. After chewing his bum and fixing the project he had set up...

I have a question about a specific behavior of the CSTR() function. I was using STR() to convert integer fields to text before concatenating the converted fields, a text field, and some new text with "&". However, this added a space before the text numeral that I couldn't have in my export...

Hello kind forum users, I have a query in a new database I'm developing that persists in being slow, in spite of all I've tried to address it. I've gone through the "100 Tips for Faster Microsoft Access Databases", "The Twenty-Something Rules For Access Development", and all of Allen Browne's...

Hi everyone, I've been lurking a long time looking for fixes and tips, and finally have a question to post that I couldn't figure out on my own. Thanks for the great resource!