Search results for query: *

I am exporting data from Access (2010) to Word and at the end of the Word document I use the following code segment to place records from a table WarePlantNonCom. The records are placed in Word but I can't find a way to line up the data from the 4 fields under their headings. If a value has...

Have been thinking about this but still haven't a clue how to do it so can't show any progress. I have a database (database 1) which isn't always accessable to users who need excess to the data in one of the tables so a link to the table isn't possible. I can store a copy of the required table...

I want to change the SQL of my query depending on the users choice but this isn't happening. From what I read qdf.SQL = strSQL should be doing this. Any help to get me over this would be welcome. tamus121 Dim stDocName As String stDocName = "PH4Part1" 'Check to see that Ending Date is...

I have a form which when opened has two text boxes populated from the previous form, e.g =[Forms]![CustomerRecords]![RegNo] and =DLookUp("FullName","LoginDetailsQuery") The form has a few other text boxes for data entry by the user and a date picker. If the user enters the date first the...

I have a table of clients and a table of their inspetion details. I check inspections details between two select details with the report based on a query. I want to allow users to select an option button and the query to list of clients who haven't been inspected during the selected dates. I'm...

Hi I am lookoing up a record in a table with s = DLookup("[ShareNumbersTo]", "CertificateDetails", "[ShareNumbersTo]=(Select Max([ShareNumbersTo]) from [CertificateDetails])") and this works ok to a point but I want the largest share number for only the selected type of share. So If I have...

I recently decided to use input masks on postcode and telephone fields to reduce errors in the data entered. I entered the smae mask in the table field and the form text box. For the postcode I used ">LL09\ 0LL" without the quotes and it works well. I have looked at the tables and everything is...

I have a combo box (with value list) on a subform which limits users entering data following an inspection to a list of 8 different types. When a selection is made, the value is removed from the combo box list so that it can't be entered twice at any one inspection. When the user moves on to a...

I have two tables, one holding records of locations the other various types of visits on various dates to these locations. Some locations have no visits yet and therefore no type of visit. Each location can have one or more visits on different dates and one or more type of visit for each date...

Hi, hope someone can help. I have a access report which has a query as the record source. This selects the top 6 records from a table using "SELECT TOP 6". I would like to have a text box on a form for the user to enter a variable amount of records to be listed. I can't get this to work if I...

I have Grid references stored in a table with address of businesses. They are in the format J123456. I have been thinking that it would be useful to list addresses within a short radius of a particular address – say approximately 3km. I have done some searching for this but haven’t found...

I'm passing the form name with code in a command button so I can move and return to the same form (Main menu) stDocName = "NoticeBN2" Me.Visible = False DoCmd.OpenForm stDocName, OpenArgs:=Me.Name When NotiiceBN2 is closed I have in the form_unload event If Len(Me.OpenArgs &...

Hi first time posting. I have been struggling with this in various forms for days. When previewing a report this works :- [DoCmd.OpenReport stDocName, acPreview, , "Inspection_Type = Forms!InsReports.Reporttype1"] but I want to base the report on various criteria depending on users options...