Search results

I have a table with Containing Controllers names and Costs for the year . I want my code to firstly extract a distinct list of controllers and for each controller query the main table with a filter on the controllers name and create a new query. I can get the first bit to work but when i try to...

The reason I want it in code rather than a query is that the function is used in conjuntion with a report. There are 8 tables and 8 reports some have differnt headers for the reporting date so I thought why no write a funtion to be used in the format part of the report that could query a...

I want to write a function that will check for the reporting date in a table. Where tblname is the table name and repfield is the field in tblname that contains the reporting date. I cant get it to work . Can anyone help. Much apprciated Function sTableReportingDate(tblname As String, Repfield...

Im trying to put some sql together and I can seem to get the syntax correct Im trying to query a field where the records are not equal to "" (empty string) How do i put "" in sql code heres my example sSql = sSql & " AND [tbl 03 all positions].Exception <>" & Chr$(34) & Chr$(34) and below is...

Thank you thats very helpfull

Can anyone provide me with some sample code for droping and relinking linked tables. The simpler the better Thanks in advance

thanks

Im looking for a piece of code that I can call at anytime to disable buttons I dont wast to have to put the code below each time but Im fairly new to codeing. can anyone give me an example so I can get started. i want to be able to say buttonStatus = Off to replace the below Thanks...

I know how to intigtae access with Outlook but we now Lotus notes. Does anyone know how to email a table using LN. If someone knows a site with information or better still code than I would be greatfull

Cheers. very much appreciated

Try here for starters http://www.americaninfo.com/vbtutor1.htm

i want Access to open a text file and remove certain characters before importing. Im struggling. Can anyone help me with my code please. I want to replace all instances of " with \. So far i have : Dim mfile As String Dim mfileO As String mfile = "C:\WINNT\Profiles\mcgrco\Desktop\MYFILE.txt"...

please help if you can. I have a form called exceptions based on a table called exceptions. For each exception there is a single form. Also on the form is a search box. The user tpes in part of a word displayed on the exceptions form in the search box and the seach box queries another table...

I cant get the file len to work . it keeps coming up with an overflow message. the code Im using is Function size() Dim DBsize As Byte DBsize = FileLen("C:\Program Files\calers\uat\calers.mdb") MsgBox DBsize End Function

When my database opens up I want a piece of code that tells the user what size the database is. Ultimatly i want to warn the user when the database goes over a set size to compact it. Thanks

does anyone know if its possible to changed linked tables from one database to another in code. Thanks

Me either. Anyone help

If you want the excel spreadsheet to not display the message on open then create a macro in excel called auto_open (similar to autoexec in access)enter the line Application.DisplayAlerts = False this will turn the msg off. Be sure to turn it back on at some stage Application.DisplayAlerts =...

I have a simple loop code which stops once a value is true. when this happens I wasnt the procedure to wait an hour before resuming.Does anyone know how to do this. thanks

thanks but that still gets stuck. I got it to work using Function CmdSetTheTimer() Dim StartTime 'Timer events StartTime = "08:30" Do Until Format(Time, "short Time") = StartTime If Format(Time, "short Time") = StartTime Then Exit Do Loop MsgBox "The time is " &...