Search results

Make sure you have not declared any variables or named any Fields "Date" "Date" is a reserved word. If all else fails, use something like: MyDate = Format(Now(),"mm/dd/yyyy") 'or whatever format you need your date to be

If you're referring to the Date() function; Does it work when you use the Now() function? or vis-versa?

I agree with AtomicShrimp, but I also understand that your scenario is unique and thusly requires a unique and creative solution. I'll play around with the idea today and let you know. Is it possible to remove the confidential data and post your db? It almost sounds like something from...

Hmm. I was going to suggest nested loop statements, but without some insight to the math involved here, I'm not so sure. Can you enlighten us; What is it that you're ultimately trying to accomplish? Maybe if you wrote out the entire procedure the 'old-school' way then we can look at making...

Duplicate Thread

This is just air-code, but it looks solid to me. vPrivate Sub dpt_Click() On Error Resume Next Dim I As Integer Dim puck As Object Dim cthick As Object For I = 1 To 6 Dim strSQL As String strSQL = "DELETE FROM [dptdata] " & _ "WHERE [CZTNumber] = 0 AND [Sub Lot Number] = " & I...

A couple things. 1. If you want the task to run when you are away from your computer: a. Supply your username and password to the task b. Sometimes Logging-off prevents a task from running, Try locking the computer instead. (It shouldn't matter if you gave your username and password to the...

Make sure all users have full (read/write/delete, etc) permissions on the folders in which your databases reside.

Make sure you have full read/write permissions on the folder in which your project resides.

If you are running the calculations from code, you might be able to use a loop like; Do Until Not IsNull(YourValue) or YourValue <> "" Your Code Here Loop

But wait, let me ask you this; Can a single tree be in two plots at once? ever?

You will have to create an indexed (no duplicates) field in the plot table that contains a combination of treeID and PlotID. You can't use Autonumber for this obviously, so you'll have to use code to create this compound-key. It may look something like this "1234_0012" where 1234 is the Tree...

lol. I hope that was a joke.

For Report/Email automation, I usually use a combination of: Microsoft Task Scheduler Microsoft Access & CDO If Lotus connects to an SMTP server on your network, CDO should work. Here is a great article.

Well, you said you put ="Page " & [Page] & " of " & [Pages] in the Page Footer. Have you tried it in the Data1 Footer?

I believe that's exactly what it's supposed to do.

There are some sample databases that you can find with that search suggestion. Download the samples and take a look at the code. I'm sure once you see how it's done, you'll have no problem... and we're always here to help!

You might find a solution by creating one more table. tblOrders tblCategories tblSynonyms In tblCategories you will have records with single words like "Tonner" Then in tblSynonyms you will have records with single words like "Toner" Then you will have to write a function that dynamically...

Does each person use their own computer and log into windows with their own username? If so, do a search for the funtion fOSUserName(). This function can be called from anywhere in the database (except for tables, or course) to determine the current user accessing the object. This will require a...

Wouldn't the Column Widths property on the combobox be something like: 0";1.5"