Search results for query: *

Trying to rest all controls on a form with unbound controls back to their default values. Any help would be appreciated. For Each ctrl In Frm '.Controls Debug.Print ctrl.Name If ctrl.ControlType = acTextBox Or ctrl.ControlType = acComboBox Then ctrl.Value = ctrl.DefaultValue...

Hi all, I hope someone still looks at this forum who can help. I am using after effects 7 and wanted to produce an animated gif for inserting onto a web page. I managed to export the composition but an unwanted grid appears on the exported footage when dither is select. I also tried exporting...

I have a form with a combobox where the user can select a department code. I am trying to show only those records with a matching department code or all of them if the department code selected is 0. I have tried the following criteria in the query wizard iif([forms]![selectfrm].[Deptcode]...

Would anyone know why, if I type this in the immediate window debug.? #25/06/08# i get this returned ... 08/06/25 instead of 25/06/08 ? Ian Mayor (UK) Program Error 9 times out of 10 I know what I'm talking about. This must be my tenth reply.

Dear all, Having problems trying to add a record to a table with a form. The DB is ODBC linked to a MySQL backend. Other tables allow me to add records to them but for some reason I am getting the error below with this one particular table. Run-time Error '3155': ODBC--insert on a linked table...

I'm hoping to use the following to get a path to a file but I get an error with the line. Dim fd As FileDialog "User defined type not defined" I suspect it may need a reference setting but I'm not sure which it is. Can anyone help? Dim sFilePath As String Dim fd As FileDialog Set fd =...

I'm using the following code to open an Excel sheet to import the data but I'm not sure how to check if the a workbook is already open before going ahead and opening it. I could close the workbook after each call to the routine but I want to leave it open so the user can check the data imported...

I work in a University where we make constant recordings of selected television channels (20 in all). These recordings can be requested for teaching purposes via a request page onver the internet. Our web designer was in a hurry one day and decided not to use a drop down box for his channel...

Hi all, I need a little help filling in the space of the code below. the code works if the sub is in the forms module using me.form in the line For Each ctrl In me.form But I would like to make this generic to all forms and I cant seem to find the right syntax. Can anyone help? ' reset all...

Access thinks 31st of feb is a true date. I used the following in the immediate window in VBA and it returned as being true??? Try it in the immediate window ? isdate("31/02/08") ? isdate("99/02/08") It also works with 99th of June and other dates up to ? isdate("12/13/08") ...

Hi All having trouble making a report show only three records per page (using it to show three pairs of student names on a DVD so cannot alter report size or margins etc) so I thought I could do it by creating a colomn with a value of 1,2 or 3 then starting again at 1 ,2 then 3 again. What I...

Hi all, Can anyone help. I'm using a make table query to produce a table but I need one of the filed to initally have a null value (easily done by using 'startTime: null' in the field but I would like to make this lookup values ie using a combobox type selector, in another table . can anyone...

I'm using the following code to assign a value to txtdiskno which is a textbox on a report. but I get a application-defined or object-defined error. the textbox is definately called txtdiskno and is unbound. when i do a debug.print rpt.name it gives me the correct name of the report. Any ideas...

I'm using the following code to assign a value to txtdiskno which is a textbox on a report. but I get a application-defined or object-defined error. the textbox is definately called txtdiskno and is unbound. Any ideas? Function LabelCopies(rpt As Report) rpt.txtDiscNo = CopyCount&...

I normally display the backend link location on my switchboard. So I thought I would share this with you. If all links are in the same table you could use a dlookup method to look for a flag = 1048576 in the msysObjects table (normally hidden). The following displays the link if it is linked by...

Hi All Anyone know how to change this to look for the input if it is only part of the data enter in the field eg if hello is entered then it should return billyhellothere aswell as just hello strSearchCriteria = Nz(DLookup("modelID", "tblmodel", "model = '" & Me.txtSearchDetails & "'")) i...

I have a little routine which resets all the textboxes and combo boxes on the form to their default values except for two boxes which have dates as their default values. When reset, these put either =date() or date() (which IS the default value) instead of the expected date. I could check for...

Hi I copied the structure of a table to allow adding records to (this works) I now want to combine these tables. I have created a query which should do this but I get the violation error. I add all fields except the primary key as expected. Any ideas? INSERT INTO tblEquipment ( RecNum, Make...

Dim ctrl As Control For Each ctrl In Me.Form If ctrl.ControlType = acTextBox Then If ctrl.value = Null Then Debug.Print "NULL NULL NULL" end if next Help wanted to check the value of the control for null. Need syntax for purple words above. Thanks Ian Mayor (UK) Program...

Can anyone explain why I get an error "You cancelled the previous operation" when I run this code intInput = InputBox("Enter Request Number", "Program request") ' first check if number is already in the list temp = DLookup("oddnends", "OARequests", "[progno] = " & intInput) or intInput =...