Search results for query: *

Thank you TheAceMan1, I will probably toy around with that later. I currently have put in boblarson's code in my BeforeUpdate column and it works fine, however I have a few more questions. I guess my main problem here is that I am going to have people with very low computer literacy using this...

You are awesome Mr. Larson.

So I am bumping this in hopes of getting more help. I understand the concept of using the dirty command to verify if a record has been changed but I am having an issue figuring out how to link several text boxes together so that all of them must be verified as being dirty to unlock a button...

So, I understand that by using the Dirty criteria it automatically tries to save assuming the form has been changed. What I am looking for is a way to ensure that all the text boxes/combo boxes have been filled before saving and a prompt to continue if certain non vital things have not been...

I do not currently have an unbound form but I did not know if having an unbound form would be necessary to save this. My main issue is that I have much less savvy people who will likely be doing a lot of the entry and I wish to avoid having somebody type in some random stuff and then have access...

So I am currently using a subform that opens w/ "Data Entry = True" for a data entry form. However, what I would like is a button that updates the text boxes to a table but I am having a huge brain fart and can't think of a way to do this. It would be something like txtCorporation txtAddress...

Its real easy: I used a button and On Click: DoCmd.Requery "(name of the form based on your query)" I used this form as a subform which was "FrmCustomerSearchSub" works like a charm.

Would you be willing to kind of expand what I am actually telling Access to do here? I am reading it as I am declaring that FormFooter.Visible is a function of Nz(CmbYN, 0) with the the Values 0, -1 being tied to New Customer and Existing Customer respectively. What if I had several items...

I am attempting to create a Data Entry form (frmDataEntry) where I want to use a combo box (cmbYN) to determine the initial starting point. In this combo box the Row Source is: "";New Customer;Existing Customer. In the form footer I have some Tabs where the tab in total is:(tabFormFooter), and...

So I have a customer search form where the user enters parameters and it brings up a tabular subform that is requeried based on the search parameters. Basically I am looking for a way for the user to select the record they want based on the search parameters and then bring up all the...

haha Nvm, I figured it out

I have one button on the form called btnClearParameters Private Sub btnClear_Parameters_Click() Me.txtFarm_Corporation.Value = "" Me.txtFirst_Name.Value = "" Me.txtLast_Name.Value = "" Me.txtAddress.Value = "" Me.txtCity.Value = "" Me.txtCounty.Value = "" Me.txtState.Value = ""...

So I have a form which defines customer searching (frmCustomerSearch) where the user can input different information into the text boxes and when they hit the search button all the items that match the search criteria pop up based on the query (qryCustomerSearch). Basically I created a form...

The end game is to have a system set up where you would have a data entry system that you can select the number of different types of valves (as an example), then the number of each type and the types of valves. How would I go about normalizing/implementing that?

I understand what Normalization is and I know my table is not normalized but I was hoping for some advice on how to achieve this normalization.

So I am attempting to create a database containing bid/equipment/cost information for an agricultural irrigation company. I have 11 different tables, that are kind of broken into two separate "Areas" of technical information/equipment. tblCustomers *Farm_Corporation|First_Name|Last_Name...

Hello, I would like to preface this by saying I am completely inexperienced using Microsoft Access. I am a recent engineering graduate who, on the advice of some people more experienced than myself, has been compelled to learn Access since it can be a much better tool than many of the over...