Recent content by eramirez

Hi I am using an old version of an Access database (2000) which I split into a back-end (tables only) and front-end (forms, etc). I saved copies of the FE database on multiple users computers. There are ~10-15 users entering data at the same time through their FE db. Many of the users are...

Thanks Paul! That seemed to work. so just to be sure, this is how it shoud look? Private Sub addnew_Click() On Error GoTo Err_addnew_Click DoCmd.GoToRecord , , acNewRec ME.ControlName.SetFocus Exit_addnew_Click: Exit Sub Err_addnew_Click: MsgBox Err.Description Resume Exit_addnew_Click...

Hi This is probably an easy fix, but I have a basic command button on a form to add new record, but after a new record is added, I want the cursor to be a certain field. Thanks for your help. this is the code behind the button: Private Sub addnew_Click() On Error GoTo Err_addnew_Click...

thanks for the help.

sorry I wasn't more specific. Basically what I want to achieve is to have a menu button that when pressed it will open up a specific form, but before opeing the form, the user will be prompted to enter a date (ideally showing a calendar). Once the user enters the date, the form opens and the...

Hi I have a menu button set up where when selected, it runs a query asking for the user to enter a DATE. I want to use this DATE as the default value for the field. I am drawing a blank on this. any suggestions would be appreciated. Thanks Enrique

Hi I have an access table that I imported from excel. It basically has PIN# and 5 fields (numeric) that represent requested items. as I get items in I will ship specific items to the people that requested them. I want to set up a field on a form or wherever that will subtract what I sent...

re:ajetrumpet Thanks for the advice. I think I can set that up. What I have are 10 check boxes per row associated with TYPE. Each of these 10 check boxes have different field names (reas1-reas10). How do I include all 10 in the example query you gave? Thanks again Enrique

Hi I have a basic form that has TYPE and REASONS, 10 different reasons that can be checked. So each row will have a TYPE and the 10 different yes/not fields either checked or not. I want to run a query where it will group by TYPE and give me a count of all the YES responses per TYPE. pretty...

Hi I have a field called TYPE and a series of check boxes for reasons a person picked that type. I want to add up all the checked responses (YES) and group by TYPE. When I setup my query and add TYPE and for total I chose Group By, then I add in each of the checked (yes/no) fields and for...

got it...thanks! thanks to everyone's help I finally think I got it! It took a minute. Thanks again for your patience and help! Enrique

thanks again hi, I'm usually not this slow but I am still having trouble understanding. Table 1 TABLE 2 PIN# PIN# NAME TYPE ADDDRESS QUANTITY CITY MANUFACTURER They are linked by PIN#...

thanks I understand that and I will read and apply all the rules of normalization before I go any further but all I want to know is how to set it up. In laymen's terms preferably. Enrique

correct that's right I was being redundant. All I want is that when I am entering information on a form when I enter a PIN # I want the address, name, etc to be automatically populated. That's it. Let's not even think about normalization. All I want to know is how to do it. I know if I don't...

thanks After reading what normalization is I think I have an understanding of what to do. So having a table of client demographic and another for client orders is not normalized? So say none of the variables are repeated. I still don't know how to automatically populate fields? Lets say...