Search results

Thanks that cleared up everything. I cant believe I was having trouble with this. I am no where near the level of knowledge that most of you here have, but that is something I should of known. LOL

So basically in other words, what you are saying is that I have to declare the variable OUTSIDE of any Private sub...End Sub procedures??? And by doing so that variable will now be availabe INSIDE any Private sub...End Sub procedures? Am I correct on understand your response?

Ok guys I'm sorry and really embarrassed for asking this, but its so simple and I'm surprised I never ran into this before. When using variables in a forms vba module (not sure the actual name of that, but NOT a separate module, but the one attached to a form), If I declare a variable in the...

I have XP service pack 3, but not sure what service pack, if any, for Office. How do I find out. All I know that it was working just fine less than a week ago, and I did no updates to my computer nor did I install any software since, and now it's working as explained. I do remember the...

I'm using Access 2007. In the past, up until about a week ago, if i were to highlight an expression in VBA, or something in the properties box in a design view and then hit F1, the help file would pop up with a topic relevant to what was highlighted. If nothing was highlighted, or no topic on...

Hey guys, I'm back with some problems. I was able to create an automated way to remove about 90% of my customer addresses from the master list, and now I'm stuck with the last 200 or so records. For the record and if anybody else is following this, what I did to remove the vast majority of...

Thanks. I haven't gotten a chance to actually try those suggestions yet, but will soon, and post back on how it worked out.

Thanks for the quick reply. I think I mostly understood you, but by "translate" do you mean to still maunally change the fields? I guess grouping them this way would be easier than comparing 2 tables maunally. I've never used it, but isn't there something like a "like" function? If so do you...

This isn't so much of a database design question, but I guess more of a suggested technique. What I am doing is taking a master mailing list from the post office for a my town, and I want to remove all of my current customers from that master list. I have imported both lists as separate tables...

Very well spoken!!! I actually agreeded with this before posting, but never mentioned so.

WOW, that was one hell of a response. Thanks!!! you cleared a lot of things up for me with that. I never thought/knew that Access was considered a front end system. Hopefully you are correct on hoping that other people were comparing myslq to jet/ace otherwise I would still be lost. What...

This is not really a tech support question, but more of a debate/discussion starter about the differences between Access and mysql. Over the past few months I have learned a lot about Access and I also know a "little" about web design and mysql (not nearly as much as I do about Access though). I...

Yes, well, I didn't know that the runtime strips out the navigation also, but luckily, my db design included a navigation form anyway, so I lucked out there! Yes, that location on my computer is shared with read/write/delete access and the computer is constantly on, so none of that should be...

First of all I would like to thank everyone here who has helped me through my time creating this database. Without you guys I would not have a database to deploy. It is a pretty simple thing right now and will only be installed on 3 other machines running the 2007 runtime version (my station...

Just tried that and I dont think it works for reports. The message boxs' inside values came out null and the actual setting of them did nothing. When trying to write that code for reports, the Insideheight and Insidewidth options are not available in the "autocomplete" when typing of the code...

Nobody? I added a lot more information than I needed in that post. The question can be summarized as: How can I set the window size of a report in VBA when opened in report or preview view?

I recently posted a thread about creating a custom ribbon bar, and thanks to everyone who helped me there, and since that idea didn't work out 100% for me I now have a different idea on how to acomplish what I want, but still have questions on a few issues with it. The end resuly i'm trying...

Ok seems to be working now. I did put it in the table USysRibbons. i was using it in a sample database I quickly created. I just copied everything to my main DB, changed a few reference names and it works. The compact and repair on the sample DID NOT work though, but it doesn't matter now...

Thanks... there is no error now, but when I click the button it just does nothing, no error or anything. I double checked the references, ID's and form names and they all seem correct. Full XML: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon...

Ok it works kinda... I got the ribbon bar to display correctly, but something is wrong with the function or how its calling it. For testing purposes i just have one button trying to open a form. I get the following error: "Access cannot run the macro or callback function 'fncOnAction' Make sure...