Search results

Thanks I'm using 2000 and it works great, little ugly but who cares.

I'm trying to write an interface for the update and addition of customer details in a database. I so far have the below all on seperate forms. CustomerListing - A list of existing customers. CustomerDetails1 CustomerDetails2 CustomerDetails3 CustomerDetails4 dbl clicking a customer in the...

I need to store the users login and various security rights and refer to them throughout the user session as values in queries and VBA code in forms. How do i store these variables so that they can be called? I need something like session variables in ASP.

I'm creating a database with a history table. The only table in the database will be this history as it is dumped from an operational database which i don't want to get too big. I need to keep records in the History for seven years and i estimate adding around 20,000 records a day. Thats around...

More Flashyness Needed Trouble is i have about 100 stages i want to show. The message variable is update as the code runs, so the fisrt line of the code would be StrMSG = "Doing Stage 1", then the next section of code would include StrMSG = "Doing Stage 2" and so on. but how can i set this up...

I've written some really nice code for a scheduled task thats runs in about three minutes. However it looks really boring at the moment. Does anybody have any cool looking examples of some screen effects to run while its churning away. There are lots of stages to the code, i'd like to have some...

Same for a Table Tim, This worked perfectly, BUT i need to do the same with a table now. So i want the account value in First Table to act as a filter on the second table. After each filter is supplied in the loop i will export the table to excel as in the previous code. I tried to adapt...

I've been using the below code for a project which has been working perfectly, however i know have a specific email account i want to use with the code below to send emails. The code only seems to work with my default account, even if i open lotus with the other account first. how can i change...

I have code i want to start in a database with a .bat script or preferably a .vbs script. I know i can set the code to run when a form is opened and set that form to open with the database and then write the script to launch the database, but i dont want to do this. i need to directly launch...

I want to run some code which will move through a table to change variables. My table looks a little like this: Account Location Name 1001 C:\Folder1\John.xls John 1002 C:\Folder1\Jame.xls...

The below code is working (In Part) on some machines, but It does not complete the "TO:" field. The attachment and message work fine, but no email addresses are completed and so the email is not sent. DoCmd.SendObject acTable, "Table1", "MicrosoftExcel(*.xls)", "abc@abc.com", "", "", "Subject...

I'm trying to override the password request for Lotus Notes at startup so i can automate with Access. Is there a way to have Access enter the password when requested. The system administrates here have blocked me turning off the password request.:confused:

Im Getting a Run-Time Error 2287 - Check Mail application to make sure its working properly. But it is and its set as my default mail software ????

I need to send a Table as an attachment to an Email with Lotus Notes. I've browsed the previous post on this but i can't find a solution. My simple sendObject works fine with Outlook DoCmd.SendObject acTable, "Table1", "MicrosoftExcel(*.xls)", "email@hotmail.com", "", "", "test", "testing 1 2...

I need to automate the importing and exporting of files through an FTP site. The only problem being i don't have a clue how! I'll need my database to open the connection with my login and password and then import the file. Does anybody have some useful code or recommended reading?

I have two modules that i wish to run at specific times. I want one to run at midnight everynight and the other to run at midnight on the first day of the month. how do i do this and will i need to have the database open all the time or can i somehow set it to launch run the code and close again?

I want to export several forms into seperate sheets in the same Excel spreadsheet. I want the file to be saved in the same location but with the current time and date as the file name. I cant work out how to do the last bit, but as always im convinced its possible. Any ideas:confused:

Maybe i'm missing something, but....... I cant see whats wrong with this. AGE: Format(Now(),"yyyy")-Format([Table1]![DOB],"yyyy")

I't wont let me run a delete query on a linked table running from excel. Idealy id like to delete the data on the Excel sheet after ive finished with it. Has anyone found a way round this? Is it possible to control excel through Access and clear the linked range in the background.

If you do just want to join your four tables use a union select query in SQL, check the Access help. I've used it for a similar purpose with no problems. Although ive never based a form on it or tried to run data entry back through it, so that might not work