Search results

Hello all (again), As I make all these beautiful forms, I am running into a few hiccups... One was a question I posted earlier that I'll get to in a minute, but the burning question I have now is: I am creating combo boxes for my forms to display names from tables and queries instead of the...

Hello everyone, I have created several forms for data entry, and the record selector is showing more records than are actually in the tables. I have 14 records in the tables, but the form is showing 18. When I scroll through the records, some of the records show as duplicates, but are not...

Hey John, I got the "Run-time error '2489': The object 'frmNewCustomerContract, acNewRec' isn't open.

OK John, I did that. Do I click "run"?

Thanks John, but I still suck at the code game until next semester is over. I copied and pasted the code above, changed "YourFormName to the actual name of my form, and I get the error message "If 'DoCmd' is a new macro or macro group, make sure you have saved it and that you have typed its name...

Hello all, I have a form that I want to open to a new record. I set the data entry to yes under the data tab on the property sheet and saved the form, but the form still opens to the first record. So, I created a new macro to open the form to a new record, and that is not working. :banghead...

Thank you so much jdraw. I will dig into these links in a little while and let you know how it works...

Thanks, jdraw. I own a floor covering retail business, and I sell and provide products as well as installation services. The workflow starts with the customer, which has the choice to purchase materials and install the materials themselves, or purchase the materials and hire us to do the install...

Hello all, Can somone out there in the world of programming help this amateur out? I have been having a problem with creating queries, forms and reports, and was wondering if the structure of my database was in the correct order before I ask too many more stupid rookie questions... I have...

Sorry about the post being mis-posted. I am so new at this that I don't really know any type of code outside html and css. I figured that the general section would be the most likely place to ask a question like this... I really thought that the class that I am taking would teach me...

Hello all, I am currently enrolled in Visual Basics Programming l and start the first week of January. I have no idea how to write VB code and I just recently learned to write html, CSS and tie my shoes...:D All joking aside, is anyone familiar with Visual Studio Pro? Is it worth the...

Thanks John Big Booty. I will break that db down tomorrow. Hopefully you'll be around tomorrow night for more questions. Have a good evening.

Excellent, John Big Booty. Thanks for all your help tonight. I will build that form tomorrow and thank you then when it works!

O.K., let me know if I have this right; Create a form from the query I just created (qryMonthlyDetailSalesReport), add an unbound text box to the form, add this expression: DatePart("m",DateAdd("m",-[Forms]![YourFormName]![YourTextBoxName],Date())), and please forgive my inexperience in this...

But wait... Instead of creating 11 copies of the query using different criteria in each, how do I create a parameter to ask the user how many months they want to see?

Got it!!! That worked like a champ! Thanks to the both of you!

Hey jdraw, thanks for such a quick response. I am a serious novice at SQL and VBA until I start my classes in January, so can you please tell me if I enter this expression in the criteria box in the ContractDate field of my query, and what is the proper syntax? I know I'm asking a lot and it...

Hey guys, I know I'm leaning on you like a crutch, but I have until Jan. 1 to get this file up and going. I would greatly appreciate it if one of you could kindly give me the criteria to show the previous months results in a query. I know this is probably a dumb question, and I searched...

From an Access novice; I appreciate this post and really appreciate the programmers that are gracious enough to help a person like myself that just wants to keep track of what his business is doing. Thank you all!

Do I know what I'm doing? Well, thats subjective... As far as the field mentioned above, I only had it in five reports that displayed the information. My database only has 70 to 75 objects with very few records yet, so it's not to the point yet where I can easily lose information. Thanks for the...