Search results
-
L
Custom naming pdf reports generated using a loop
I have a query called qryGrpMedHMMScript which collates the data for a report repScriptHMM. I have a button on a form which when clicked triggers the code below: Private Sub Command8_Click() Dim rst As Recordset Dim db As Database Dim strSQL As String Set db = CurrentDb() Set rst =... -
L
Query summary
In my table/form I have 4 yes/no tick boxes. I have built a query which counts how many boxes are ticked in each record then another which summarises them and tells you how many records have 4 boxes yes how many 3 yes etc. On the same table/form I have 4 corresponding combo boxes with around... -
L
Select entry from combo box if yes/no box checked
Hi All I have a yes/no tick box on form this then enables two combo boxes. I also want it to change the value in one of the combo boxes. If you were to code that value as default it would be value "1". I have played around with item data and value but to no avail. Current code associated with... -
L
Issues with date carried forward
Hi all I have a data entry form with a date on. I want the date once entered to carry forward until changed. I am using this VB code currently: Private Sub Date_AfterUpdate() If Not IsNull(Me.Date.Value) Then Me.Date.DefaultValue = "#" & Me.Date.Value & "#" End If End Sub This works however... -
L
Selecting data for report issue
Hi All I want to be able to generate historical reports for work done for certain clients on certain days. I have managed to get the query behind the report to display two text boxes asking for client name then date but obviously any spelling error of differance makes it not work. Firstly I... -
L
Automatically moving data into form fields from another table
Hi All I have a list of clients in a seperate table they have an auto number assigned which is the primary key and they are also assigned to differant practices. Three pieces of info in total. In my main table the list of clients is used to populate a combobox/drop down menu. On the form for... -
L
Security disaster - locked out of db
Hi I have recently created a very basic program on access for work. I am a vet and have no background in IT other than a GCSE quite a while ago so please bear with me. My issue started when I curiously selected the user level security wizard. I thought I'd cancelled it but when I went back in it...