I am storing settings for different processes in a database. I have a table for my process names. I also have a separate table for each type of dialogue box that could store settings. Not every dialogue is used for every process. I need to compare settings used between all the different...
Thanks for your reply Skip,
I have a basic knowledge of VBA and no experience using it in excel. I will try your solution and see if I can get it to work. I will report back with my success (hopefully).
Most of the code I am using was generated by excel when I made the macro. I was able...
I have modified a macro I recorded to make it better. However, one bug I can't seem to get rid of is when there is only one column of data it tries to copy all the empty cells in the workbook to the right. I have made several attempts to overcome this, but have only proven I don't know what I...
Sorry I misunderstood. (I do that). Didn't realize you were working with a tabular layout.
Would setting their visible property to false suit your needs? And then make new, unrelated labels?
I don't know what the proper answer to your question is, but I would also like to know.
One last...
You can move them separately. I don't know all the nuances, but try grabbing the gray-ish box in the upper right corner of the control (or the label) when it is selected in design view, and move it that way. If that doesn't work, move the label that way.
One last thing: Sometimes I wonder...
I believe you can do this with the wizards access provides. Just make a form using the wizard (I would select justified in this wizard, but that's just personal taste). Then go to design view, make sure the control wizards are enabled, and make a combobox. When you are going through that...
Could you just make an unbound form for the parent form?
Then have controls for the 'repeated' data there, and use those values to set the default values for the controls on the child form. Perhaps, using the on change event of the controls on the parent and a little VBA.
But, I have a hard...
Yes, it is possible to do this. Without knowing your table structure, I can't say for sure, but, "duplicate information" has me a little concerned.
Typically, you would want to set up multiple tables to avoid duplicate information.
For instance, you would have a table which had the employees...
Thanks dhookom!
I wish I could give you two stars :/ I thought I'd seen something like that somewhere before, but I was unable to turn it up.
Aaron
One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?
Thanks dhookom,
That was the event I needed! I have another question for you though.
Value gives me the Key which is stored in the combobox, not the human-important data that I need to show on the report. So, I called setfocus and then used text. Is there another way to do this? Can I get...
My apologies, I must have misread your reply. (I am really good at misreading things)
One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?
I have the following code in the Open event of my report:
Me.LotNumber_Label.Caption = [Forms]![LotNumberTrace]![LotKey].Text
I had this code in my Load event, but it would only run when the report is previewed and not when it was printed via a command from a form.
So...I moved the code...
Drisconsult,
I hate to butt in, but, I really think you should reconsider JoeAtWork's suggestion. It is very easy to implement. (I believe Access even sets it up for you this way when you run certain wizards.) I also think everyone here in this thread would agree. I can't speak for them...
No, and because of the nature of the data - I left many things wide open while maintaining good design. However, the description of my project is essentially - "make a program that bends to us - not the other way around." And since that design was made, a key employee was replaced. This new...
Interesting point. Funny thing is, I made it that way from the beginning. It is already two fields just like that, but now, the numeric part needs to have letter. Haha! Jokes on me :P
How would you handle leading 0's as RoyVidar pointed out? Is using functions to increment a number that...
This was actually a tracking number they already had for business, and I, regrettably, set the field to number :( But, as I said above, fortunately, did not make it a primary key :)
Should have included this in the above post, but I am too quick to hit that submit button. :P
One last...
Thanks RoyVidar! I hadn't considered that possibility.
I definitely agree with that. Fortunately, I learned that one (from this forum and other places) before I started coding the database. I believe it has saved me much grief. That and this business is so crazy, it didn't take long to...
Don't make a field a number, just because you are going to store numbers in it. Because, one day, it just might need to store a letter also. Learning this the hard way, right now.
Example: Numeric tracking numbers - sometimes, things get messed up and now they need #####A and #####B. And...
I want my query to only return unique results. I have made acceptable queries using either Group By or Distinct. I read that you can't trust DISTINCT to de-duplicate correctly in some situations. Does Group By suffer from any issues? Is there any other differences that I should be aware of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.