Search results

sure you can: WHERE (((tblSampleSubmission.SubmissionNumber)=[Forms]![frmReportPreview]![SubNumber] or tblSampleSubmission.SubmissionNumber)=[Forms]![frmNameOf2ndForm]![FieldName])) Dave

Chris, you need to get away from 'flat data' (spreadsheet) presentation and think database which is not something that you can do in a couple of days. I would: 1) create 2 tables related to each other, Table1 contains details of your cottages and Table2 contains the range of dates. 2a)...

why/how do the tables look different? Dave

DoCmd.OpenForm "frmName" Dave

sure there is, check out the CreateObject Function in Access Help. Dave

have you considered a subform? If you have a form that contains unique information (person v. project depends on your output requirements) with a subform in it listing the related information should do the job. Maybe. Dave

first a few questions to you: 1) what happens if in a month's time you need to enter data for consultant4? 2) what happens if in 2 months time you need to enter data for service5? 3)etc. Dave

OK, took me a while but I found it. the basics of the SQL: SELECT [tbl_Orig].[UniqueKey], (SELECT Count([tbl_Orig].[FieldToCount]) AS AutoNum FROM [tbl_Orig] WHERE ((([tbl_Orig].[UniqueKey])<=[tbl_Alias].[UniqueKey]))";") AS Total FROM [tbl_Orig] AS [tbl_Alias]";" my example: SELECT (SELECT...

g'day, I would group on the faculty field and count the student names. The following SQL count the number of post codes for each state of Australia SELECT tblPostCodes.State, Count(tblPostCodes.Pcode) AS CountOfPcode FROM tblPostCodes GROUP BY tblPostCodes.State; Dave

I never used the procedure but check this site out: http://easyweb.easynet.co.uk/~trevor/AccFAQ/ see article "Sequence number of the fly" under Queries Dave

I seem to recall that when user1 is accessing a record in the BE user2 will not be able to access records in the vicinity of the record user1 is accessing. I don't remember the details (ie size of the chunk of the db that is not available), I would suggest you search Access help for "Record...

Split the db up and keep the tables on the main server. A copy of the FE should be kept as a master (wherever you wish) and a copy should be placed on the hard disk of each of the users pc. Each FE should be linked to the tables in the BE. Dave

I would use combo boxes where cbo1 lists the cottages and cbo2 updates the information based on the selection in cbo1. Dave

try the query in the query environment and see if it works there.

this is a bit crazy. If I have V:\etc.\Imports I get the msg with "Imports" If I have V:\etc\Clearances I get both msg Imports and Clearances checking the values in code shows both "import" and, after the step through, "clearances". ????

thanks for the quick reply Bob, I changed your code slightly If InStr(1, Me.txtDirName, "import", vbTextCompare) > 0 Then strValue = "Import" MsgBox strValue End If If InStr(1, Me.txtDirName, "clearance", vbTextCompare) > 0 Then strValue = "Clearance" MsgBox strValue End If when I click on...

You cannot not display the product name many times in the query. You can do so in a report but not in a query. BTW, name is reserved term in Access. I suggest you change the title of this field to something else (eg. ProductName). Using name as a field name could create problems for you in a...

if you want the top 50 records in a query use the TOP predicate: SELECT TOP 50 FirstName, LastName FROM Students WHERE GraduationYear = 1994 ORDER BY GradePointAverage DESC; the above query will display students with the top 50 grades. Dave

you should have the tables in 1 db (back end - BE) and the user interface (front end - FE) in a 2nd db. A copy of the 2nd db, linked to the 1st db, should be installed on the hard disk of each user. This way users can access the BE at the same. Access will still block some of the records used by...

g'day, I have a form with a text field (txtDirName) from which users can select a directory. The directory can be selected at random but must partially contain the value of either "Imports" or "Clearances" (eg. V:\ManufacturingData\Imports). I want to make 1 of 2 buttons visible based on the...