Search results for query: *

I eventually got there myself This procedure worked for me. CREATE PROCEDURE archivesuser.sp_Settables @tablename nvarchar(255) AS DECLARE @showfield1 nvarchar(255), @showfield2 nvarchar(255),@a nvarchar(255) SELECT @ShowField1= ShowField1, @ShowField2 = Showfield2 FROM fieldspecifics WHERE...

I have a list of 300 tables saved in a table called fieldspecifics I have an aspx page on which I have a listbox where the user can select a table When a table is selected I want the page to display the data from fieldnames which are specified in the fieldspecifics table The fieldspecifics...

Use Now() -1

Thanks. That worked

I have 2 combo boxes the first updates the value selected in the second combo box; if a checkbox is ticked. e.g. Supplier Company is selected in cboFirst. The checkbox is ticked if we also sell to them and if they have never before been identified as a company we sell to I want to...

Thanks that way worked as well

As far as I remember this works I've called the table Categories and combo box cboCategory. Private Sub cboCategory_NotInList(NewData As String, Response As Integer) Dim strMsg As String, rst As Recordset, db As Database strMsg = "'" & NewData & "' is not in the category list...

It is an Access 97 database. I had to set a reference to the ADO library (Microsoft ActiveX Data Objects x.x Library - msado15.dll). before it recognised your code. Thanks after that it worked.:-D Does this mean I have to set a reference from within the Modules window Tools,References to this...

I have a procedure which checks for receipt files. The following procedure works in that it amalgamates all the files into one file; but the file names are retrieved in no particular order, which means receipts are not ordered. Open MyFileOut For Output As #2 MyName = Dir(MyCriteria) '...

I also had this problem. Create a new database. Open the database you are unable to compact while holding the shift key down to disable any autoexec macros from running etc On the File Menu bar select Tools, Options and then on the view tab select show System Objects. In the new database goto...

I have tried it and it worked. I didn't realise I could schedule a task to run at intervals throughout the day. I've put down exactly what I did, as its not completely obvious how to run a batch program at time intervals Double click on My computer, double click on Scheduled tasks double click...

I want to start a scheduled job to run a DOS batch file every 15 minutes. How do I do this?

ODBC connection failing from a report in access97 on a win2000 pc. Fails on entering code for detail_format event Works fine on an NT pc Went into the design of a module and selected tools, references from the main menu. Missing: Microsoft Calendar Control 8.0 I did a search for mscal.ocx on the...

I have also got this annoying problem occuring. Any time it occurs I run a make table query to select all the fields in the table except for the memo field, for the records affected. I then delete the records affected in the original table and run an append query to append the data from the...