Search results

Not a problem :) I'm still trying to completely figure out how to use it. I will let you know if I come across anything else.

It looks like all the other sections are now fixed so when choosing the "US" currency the $ symbol is used. The only section still not updating is the "Billing Default Rates" in the Administration Centre / Preferences.

Bob, I tried it that way in the beginning and it didn't work :confused:

I had actually tried that as well. I just copied and pasted verbatim "what the code should read" and I am still get the error: Runtime Error: 3001 "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

Is there anyway you can show me an example using my code where to put this code. I tried putting the code under the With iMsg section. I tried it before .To = code and also after the .Subject = code. Then it tells me "Object doesn't support this property or method" Please help :)

I was getting hopeful. I what you said. but I keep getting the error: "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Here is where I put the code: Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") Set...

Is there any code that will allow me to send an e-mail as "High Priority / High Importance" through Access? Here is the code I am using currently: Private Sub Save_Click() DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim mail Set mail = Nothing ' Send by...

Another solutions you could use is the acZoomBox command. Set it as an Event Procedure on the "Double Click" command. Then you wouldn't have to worry about scrollbars on your form if the text didn't fit the form.

I have been racking my brain for months trying to figure this dilema out. What I have is multiple databases (used for different functions/departments) that can be open at one time. I have designed most of them to to be pop-up (more app looking than access db) databases (using the...

Our IT will only support SQL Server Database so I am actually in the process of converting the data over to SQL.

I too have been developing databases for years for different companies I have worked for in an effort to reduce associates time by having the database(s) do the brunt of the work for them. If you read into the company/your initial paperwork with the company you will probably see somewhere in...

Here is an example of the code I use in SciTE for a new install of the database: ;Script to Install PELA (Without the need for a .bat file and using less code with more accurate results.) ; ;Script created by Jason Boney 10/10/2006 ProgressOn("PELA is Now Installing", "Please Wait.....", "0...

You would only need it on your own computer as the developer. Once you have created the code it compiles it to an .exe file and you just have the database point to the .exe for the update from a central location.

Hi guys, I am the one who originated this topic and over time I have come up with a new method to handle all of this that is more user friendly as it will show a progress bar and messages to let the user know what is going on. Also one thing I do if I am updating the database on the users local...

Thanks for the help I will try and see if I can get this normalization figured out and do some searches on here. :)

I will see if I can get it normalized. (I'm not very good at that part) How would I link up the contacts table with the main table to make sure the data showed correctly? I am taking over a currently designed database; and I'm trying to make improvements upon it.

Can anyone help me with how I can accomplish this? Here is what I currently have: 10 SQL Pass-through queries to update different Date field (Date1, Date2, Date3, etc.) based on the value of the next date field. This is how each individual query is set up (there are 10 in total) UPDATE...

I am trying to sift through search results now.. Still no luck yet. I will try using your search criteria to see what I can find.

Do you know if there are any sample databases that shows examples of this or of the code so I can get an idea of what I need to do (table structure, code, etc. wise)?

Is there any way it would be possible to have a number automatically created using NZ() or DMax function; based on certain criteria and also when creating the number preventing a duplicate number creation in the even of a simultaneous record creation? Here's my example: I have a CCN Number...