Search results

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...

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...

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...

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...

Hello. I have 2 tables. Table A has PIN#, NAME, ADDRESS, ZIP, ETC. This is the table where I want to lookup values. Table B has other information on new orders. It also has fields PIN#, NAME, ADDRESS, etc. I created my form using Table B. What I need to know how to do is when someone types...