Search results for query: *

Can anybody tell me where to find the French, Italian and German Acess run time langauge sets. Microsoft tell me that they are available without buying the relevant Office copies but in spite of searching the country specific MS pages I can not find them. Thanks in advance Peter

I have an application that functions as an access (2000) file on any computer. When compiled as an .mdb file it continues to function on the machine that created the file but crashes on another machine with the message “Execution of this application has stopped due to a run time error” Both...

I have an application with a custom menu bar (File Tools etc) and a custom tool bar. I am now trying to change the contents of the custom menu bar. I can not remember how I set it up and I can not "get into" it to add to the functions available. I right click the item and select customise but...

After using the Developer software to create an application is it possible to issue patches (as forms) that will not impact existing data? My application has import in the menu but I can not find a method to save a new form individually - only as part of the main database. Thanks for any pojnters

Is it possible to insert the equivelant of an IF - THEN statement into a query calculation, something like: If [FieldName]= false then.... else ..... All efforts so far failed. Thanks in advance for any advice

Is it possible to format the contents of a text box on a form according to the results of a DLookup to the contents of another text box on the same form? I should also advise that this form is populated from a query and goes straight to print It is never seen by the user. I am trying to avoid...

My application has conventional client files, First Name, Family Name In addition it has students held in a separate table. I need to avoid the unlikely event of two brothers attending the same session. qryCheckClient works and returns required information. qryClientID updates the student table...

I am producing invoices from the client table The client table currently uses First Name, Family Name. As these are sized for the longest names there is often a big gap between the First name and the Fasmily Name on the printed document for example Jo Coley Because Jo must also allow...

I have a loop that performs three functions in each loop. I want it to stop when it reaches a variable integer but it continues to the end of the loop and so (in this example) adds two steps before completing. I have tried initiating the variable -1 and this results in one short of the required...

I have a report that uses the iif function to enter two currency amounts depending on the state of a check box in the underlying query. =IIf([Private]=True,!NumberStudents*[Tuition],[Tuition]) This works fine and I am able to total the amount in each row [field]+[field] I can not make the...

The following code has worked well but has now stopped with the error message "user defined type not defined" at the line Dim rsNewBook As DAO.Recordset. I can not understand why it has stopped. Dim varBookTitle, varPublisher, varSupplier, varBuyPrice, varSellPrice, varMOQ As Variant...

Good morning (at least in Italy) I have used a combo box to retrieve data from a table and implemented the Access 2000 Developers Handbook not in list solution. Works perfectly but.... Later I want to use the contents of the combo box as the basis of a select query and the query does not return...

I get an error message against line "Set rsInvoiceCopy" etc. "Too few parameters. Expected 1" with this code. Dim rsInvoiceCopy As DAO.Recordset Set DB = CurrentDb Set rsInvoiceCopy = DB.OpenRecordset("qryCopyInvoice", dbopendynaset) rs.Open "InvoiceCopy" I am having trouble...

My problem is writing a loop within a loop (for holiday check) and resetting the date to date+7 after an adjustment for holidays The first loop works perfectly ElseIf varSessionsPerWeek = 1 Then varSessionsTotal = Forms!frmCourseStart!TotalSessions varCode = Forms!frmCourseStart!Code...

I have a loop which creates a timetable based on user input of the first date and the frequency. Do While varSessionsTotal > 0 With rsTimeTable .AddNew 'Creates new record in the table !Code = varCode !StartDate = varStartDate !From = varTime1 !To = varTime2...

Hello I have a routine that creates a timetable based on user input. One session a week, start date assigned to a variable + 7 days Two sessions a week the same but a loop that looks at both and so on. This works perfectly for up to seven sessions per week I am trying to make the routine check...

I have a routine that creates a timetable based on user input of the first date - it just adds 7 days. As an enhancement I wanted to make it check for holidays when the business would be closed. I thought a good method would be a table of holiday dates and use DLokkup but I keep getting the "You...

I have a bound box on a form, the box is formatted as a date. On exit from the box I want to check that there is some entry and produce an error message if the box is empty "You must enter a date here..." I have been trying if / then statements and have attempted every format I can think of if...

I am trying to run either of the following lines. varBegin = Weekday(Date, Forms!frmCourseStart!StartDate) varBegin = DatePart(d, Forms!frmCourseStart!StartDate) varBegin is a declared variable Forms!frmCourse!StartDate is a user input date on a form which is open when this runs (format...

I have a date (dd/mmm/yyyy) held in a variable I am trying to identify the actual day of this date using the DatePart function. I know this must be simple but I can not make it work. I have looked through the forums and the access help files to no avail. Please help if you can. Best regards Peter