When trying to delete a list of folders from the directory structure (from within VBA module), and then create a set of new folders, based on a generated list, a Dr Watson's error occurs. The error seems to be randomly occurring, as some nights it'll work and other's it'll fall over. Two issues...
I have a continuous form that initially opens showing all records from a table called DESPATCH_HEADER. In the form header are four combo boxes (TargetDespatchDate, SiteCode, Squad, LoadPoint) that are used to narrow down the records displayed by this continuous form.
BUT, I'm having problems...
I've done something similar in the past but have used a DATA_SOURCE table. In this table you store unique names for each of the database tables, the number of fields in each, the name/position of their keyfield, etc, etc.
The form that I have to capture the data has controls which are named...
Using MSAccess 97 then you can insert a PageBreak after your subreport, and play about with the layout such that your mailing label is centered on the second page. (PageBreak Icon on toolbar )
If using MSAccess Ver 2.0 then the process is the same but with a different button face - I can't...
Assuming that your textbox is bound to a field in an underlying table, access the table in Design View and check the data type of that field. It should be set to 'Text' and the Field Size property should be set to 255.
It's possible that the data type may be set to 'Memo' which accepts 64000...
Deegan,
Try creating controls on your form which are bound to the appropriate fields in your underlying table. Then, use the DLookup command in code.
E.g.
Controls: [t_license]; [t_state]
Fields on form: [t_license] bound to 'license' in underlying table; [t_state] bound to 'state'...
Have you tried creating a recordset to search the linked table. As long as you open the temporary recordset as a Dynaset there shouldn't be any problems. Also, make sure you use the Find methods as Seek doesn't work on Linked Tables.
If you need any extra help then mail me on...
Why not try creating a temporary recordset to do this??
------------------------------------------------------
Dim mydb as Database
Dim myrec as RecordSet
Dim criteria as String
On error goto err_egcode
'set up temporary workspace
Set mydb = dbengine.workspaces(0).databases(0)
Set...
Try inserting an unbound Text Box onto your form and calling it something like [t_mytime]. Now, on the OnTimer event for the form try inserting the following code:
--------------------------------------------
On error goto err_form_timer
'set the ControlSource for the text box...