Search results

Thank you for this. Although 99% of your video was very much out of my league I managed to gleen what I needed - I am a budding amateur with no more than a GCSE in ICT. For anyone who is interested my final code is below and it now works as I wanted it to Private Sub Command8_Click() Dim rst...

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

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

Apologies as I had set field as lookup in both form and table it as interfering now works. Thanks

Thanks for your reply. Unfortunately this doesn't solve the issue when I used code: Me![FL Lesion] = Trimmed which is the value I want the box comes through as blank if out on interest i put = 1 is comes up as 1

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

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

Hi I have fixed the above problem by adding code to VB for auto updating next record. I am no however having a slightly different problem. There are 3 fields which I want to auto update on new records until changed. These are client name, address and client ID. Client name is changed using a...

Hi Thankyou very much for your guide. I have one field which I want to also fill into the table (second part of your guide) I am having an issue as I already have an event procedure in after update for the combobox to make it carry forward to the next record. How do I get it to do both...

Hi I tried the above fix but it doesn't seem to work. I have set up the form with two fields a drop down box linked to client list table and a text box with date input mask. My query links to the main database which has two fields the same as above. I tried entering the above code and it didn't...

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

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

Thanks I don't think that will work as I tried to open on a different computer and it still didn't work. I also then transferred the .mdb shortcut and tried pointing it to the system.mdw on the new pc but it still said I didn't have permission to open the file so I think the issue is attached to...

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