Search results

Try something like.... SELECT tblRetest.TestDate , tblRetest.Frequency , DateAdd("m",[frequency],[testdate]) AS RetestDate FROM tblRetest; HTH :cool:

template ?? Just curious, have you taken a good look at the stock Inventory Control database template that comes with Access? :confused:

Allow Deletions ? Put the form in design view. Make sure that Allow Deletions is set to yes. If it is set to Yes, set it to No, save the form, set it back to Yes, and save it again. Or, change the DoMenuItem to Application.RunCommand acCmdDeleteRecord You may get a response from other...

Excel is seeing the imported text that starts with zero as a number, and since no number starts with zero, it is truncated. I would make sure that the field in Excel is formated as text. Might even be easier to attach the spreadsheet as an Access table. HTH

Sorry, Dave, but I have now uninstalled MySQL in favor of the new MS SQL Server Express (new free program from MS). Wish I could be more help. :o

Simple query.... Try this: SELECT tblSrvCall.svcNum , tblSrvCall.dateOpened , tblSrvCall.svcStatus , tblDetails.dateworked , tblDetails.timeworked , tblDetails.memodetails FROM tblSrvCall INNER JOIN tblDetails ON tblSrvCall.svcNum = tblDetails.svcNum; HTH :cool:

I think I see the problem, too many words... :rolleyes: :rolleyes: Just kidding, the above works fine, but the mod suggestion is a good one. Try this: Function RoundToNearest2(dblNumber As Double, varRoundAmount As Double, _ Optional varUp As Variant) As Double RoundToNearest2 =...

Try this.... Any pecentage calculation should simply be the total number of items at issue divided into the number of those items that meet your criteria. In other words, if you have 8000 total records, and there are 5000 with contracts, then the percentage is simply: 5000 divided by 8000, or...

As close as I can get... Does this help at all? TRANSFORM tblBooth.Booth AS Booth2 SELECT tblBooth.ID FROM tblBooth GROUP BY tblBooth.ID PIVOT tblBooth.Booth;

Sounds like User1 is opening the db for exclusive use. :confused: Open shared, OR give each User their own Front-end db.

Define Primary Key. A Primary Key is a unique record identifier in each table. Define Foreign Key. Foreign Key refers to the Primary Key of another table. The Foreign Key must be the same field type (Number) as the Primary Key. Define a "relationship" between two or more tables. The data in...

custom autonumber Take a look at: http://www.experts-exchange.com/Databases/MS_Access/Q_21111021.html :cool:

missing link... You need to add a field to your jobs table called ColorID, and then link the two tables on the ColorID field and update your jobs table so that the proper color id is inserted for each job. From the Help file: If tables in a query aren't joined to one another, either directly...

Or... Or, you can try this. This is the datasource for a form with a command button that simply does a "Me.Requery" SELECT DatePart("yyyy",[Date]) AS DateField , tblOne.Field2 , tblOne.Field4 , tblOne.Field3 FROM tblOne WHERE...

technicalities Don't mean to be a stickler for technicalities, but, uh, wouldn't that be a violation of good ol' MS's copyright? :rolleyes:

Excel...? I would do it in Excel, and embed it in Access if needed there. ;)

If the field is fixed width at 10 characters, try this... create an update query to update the field in question [here labelled Field1] UPDATE tblOne SET tblOne.Field1 = Left([field1],7); HTH :cool:

Try this... Private Sub Command1_Click() On Error GoTo errCommand1 Screen.PreviousControl.SetFocus RunCommand acCmdInsertObject Exit Sub errCommand1: Select Case Err Case 2046 MsgBox "OLE field must be selected before running this procedure.", vbCritical, "Not...

Yes, or just link to remote table That is fine, but you could also just link to the other remote table and not worry about maintaining two sets of data. Just a suggestion, the above answer is fine. :)

MySQL functions MySQL has two functions to help; Password and md5. md3 creates a 128-bit hash of a password string. [recommended method] Password calculates a password for your password string. [not recommended] HTH :cool: