Search results

What you can try is creating an import specification. Select Import from the menu, and after completing the specification, save it. This can then be used in the import command. The specification will allow you specify the types of date, seperator, fields etc.

Division by zero C/D where D = 0 is the cause of your problem

far better to implement security properly using a workgroup , after all that is what it is there for. Search this site for security, workgroup, logon, login, to find all the posts and links regarding this subject

I get this a lot and it it usually caused by an abnormal shutdown which leaves the DB lock file 'in limbo' so to speak. What I do is to log into the db as the administrator then log off, then ensure the lock file has gone, if not then I delete it. Another cause is permissions, each user...

my appologies, lists are slightly different. They have a fixed width.

you don't cancel the event you set the cancel variable that is an internal variable passed by Access to true If (Audit_Date < (Date - 45)) Then MsgBox "The data you are attempting to enter exceeds the 45 day limit and cannot be accepted." Cancel = True End If

first you will need an input mask on the text box, e.g. 99/99/9999 for dd/mm/yyyy or mm/dd/yyyy then you apply a date format of mm/dd/yyyy to the text box. Now if a user enters the data incorrectly it should be apparent when the format is applied. you could also split your date for data...

percent can be a bit strange to use as 60 formatted as a percent, is displayed as 600%. percent is only used where the value is between 0 and 1 so .59 is 59%

A combo box has two widths, one is the width of the actual combo box say 10cm the othere is width of the list, I usually set this to the sum of the widths of the visible columns e.g. 20cm + 30cm so when the list is dropped is dropped down it is 50 cm wide

how can you fill up a table? Access has a 2 gb limit on the size of a database

Access 97 store the workgroup manager here C:\WINDOWS\system32\WRKGADM.EXE other versions store the .exe elsewere, so search. Versions greater than 2003 ( I may be wrong here) have the workgroup manager as a component that can be called directly from the access dev environment, proballby from...

Assuming the Query returns a scalar ( a single piece of information), then the easiest way would be a DLookup Function, and the Control source would be =DLookup(........) However if the query involves more than one table then use a DAO or ADO recordset, place the code in a function, set the...

Did you do as a poster sugested and created a short cut in the format PathToAccess PathToDB /WRKGRP PathToWorkgroup or you can join the workgroup by opening the workgroup manager, then try to open the db.

either include this field in a query which can be used as the record source for the form. Or use a DLookup function.

The default workgroup file probally has a user ID in it, plus a password. Do you have an IT dept? if so why not request a restore of your DB, you do keep backups, don't you. Or re-install Access, this will create a blank default workgroup for you then try open your db.

Use the form creation wizard to set up a continious form. This is a form with multiple rows. Then edit the form to add a check box to the row. Sending the email may be accomplished in two ways, either use the After update event of the check box to determine the state (Y/N) If Y then use the...

Why did you not post your solution on the forum? why is your post dated oct 2007?

you need to turn your select query into a totals query , using Groupby on the POs and Sum on the item costs. Depending on your version of Access you may find the menu option on the view menu when in query design mode.

its a delete query you require, not a macro. DELETE * FROM tblYourTable WHERE Yourdate <= #mm/dd/yyyy# substitute the date values for mm/dd/yyyy (note the format) But before you actually delete the records, create a select query first to determine if the correct record set has been selected...

first thing to do is convert the underlying query to a pivot table (cross tab query), then specify the column headings in the query. Finally change the layout of the report to reflect the new record source.