Search results

Oh good to know. Thanks. I dont have a use for it now, but I'm sure somday soon I will come across something where I will need to do something similar

Access 2007

I have a button that should "activate" (or set focus to) my Quickbooks application. I have hardcoded the title bar caption into the appactivate function and yesterday it worked just fine. Today it would not, but I realized why. The title bar of my QuickBooks application changes depending on user...

Ah! Simple yet effective. Thanks. And just for future reference, if I had a picture or something in the form with the same situation, where I wanted to hide it on some records and show on others, that would be impossible right? At least for a continious form view?

I have a form I am viewing in continuous form view and the layout is similar to what the datasheet view would be. My question is quite simple, but hard to explain. For sake of simple explanation, I will use this simple example… Lets say my form is set up to display 4 columns (fields), but...

yes you're right, technically speaking, I would be the only one making changes to the design, and this "backup code" would be for me when I forget to backup, which happens a lot! Lucky for me this last backup I am working off right now was a recent one. The last time I backed up before that was...

Thanks... That code threw up a few errors, but no worries though. I found which line of code was causing my backup to crash on compile, and removed it. So my backup is now working just fine, and I made a backup copy of that. I guess I'm officially giving up of trying to repair my original copy...

By the "Partially' copy do you mean the backup that crashes on compile or the original that I am having the major problem with? And to delete all the code the way your're suggesting I have to set the Has Module property to no for each form in my DB? So, after that is completed, how do I get...

Sorry, i guess I should have posted everything I have already tried. I have done all of the following with no luck: Hold SHIFT while opening: opens database, but every time I open a form or anything that any VBA is attached to I get that same error, which is just about every object inside my DB...

Earlier today I posted a question about why my database would be responding slowly in design mode. It wasn't anything serious, but more of an annoyance. I now have a more seroius error that I dont know is realted to my prevoius problem or not. I deleted my previous post and am now starting...

Sorry for the delayed response... No not usually, but I did compile it when I was having the problem and no errors. It is working now, so its not that important to figure out why it was happening, just thought I'd post and ask since I already wrote it BEFORE i fixed it myself.

Hello again. I am getting an error on the open of my database and I cant figure out why. The error is: "The expression OnOpen you entered as the event property setting has produced the following error: Return without Go Sub." Now I have narrowed the problem down to the open of my startup...

Thanks vbaInet, was just about to post the same thing, but you beat me too it. Keep me informed on how everything is working for you guys.

Yes I created it in Access 07 and am unsure how it will react in other versions. I did not try what you have suggested a little whilt back, but only because I got this workin before that (for my particular database at least). I am no expert when it comes to designing and answering questions, and...

Resurrecting this post once again!!! After much searching and playing around, I got it working exactly as I needed. For anyone following this thread and also for the MANY menus I need to create, I created a database tool that will create the command bars and commands (buttons) in an easy to...

I'm sorry, I should know how to do this, but having a brain fart right now. I am such a quick learner when it comes to Access and coding, but also forget the simplest things quickly when I dont use it for a while, and I haven't designed anything in Access in a month or so. Could you give me a...

I have a main form that has 2 separate subforms (NOT to be confused with a subform with another subform INSIDE that one). Lets call them Subform1 and Subform2 for ease of explanation right here. What I need is to link a child field of [MenuID] in subform2 with a Master Field of [MenuID] in...

This is funny. I have a button on a form where one of many lines of code is a very simple "me.[Status ID] = 4" It always worked in the past, but I modified some code before it and now whenever it gets to that line I get the error: "You cant assign a value to this object" . None of the...

Thanks to both of you. I originally thought of using recordsets, however I did not know the syntax for referencing fields in the recordset. Now I know! Thanks

I am trying to create a for loop, looping through each record in a particular table. Then I want to set the value of each field to a variable and do other calculations with them, then repeat (loop). I know the code below is way wrong, but I made it "literal" to make it easier to explain...