Search results

Hi, I have a query with 3 fields (RecordDate/Site/ComplaintType) I have added Criteria in the RecordDate field to select a date range & I have added Criteria in the Site field to select the site. What I am looking for this query to return is a subtotal of each complaint type recorded at the...

I have a command button within a form, When the user clicks on the this command button I wish for my db to- Run a qry to colate the necessary info Open Windows command prompt Transfer the info provided by the qry into command prompt as text (with the idea of using the messenger service) send...

I have just finished my first ever database and will be installing it onto the companies computer network soon (hopefully), There are a number of users at various work stations who will need simultaneous access to this db- I have done some background reading into this already but most sites...

Hi all, I have a form for entering record information into a table- within this form there are 2 fields (that correspond to 2 fields within the underlying table) that I would like to auto populate with information to save the user having to manually type this in every time they enter a new...

Hi all, I have 3 forms Entry/Analysis/Follow Up, these let users add info into records held in 1 table- Active Complaint. The entry form has a command button that opens the analysis form & the analysis form has a command button to open the follow up form- however if someone goes through...

I have a form (single view as opposed to continous) that has the on current event built into the form detail properties Private Sub Form_Current() If Me.Status = 1 Then Me.Detail.BackColor = vbGreen Me.Form.AllowAdditions = False Me.Form.AllowEdits = False Else If Me.Text20 > Me.RequestedBy...

Dear all, I am a fairly new user to access, I think I understand the very basic principles but this is the first time I have tried to put them into practice! I am trying to build a customer complaints data base-The main table holding data on 'active' complaints with an Entry, Analysis &...