Search results

Im having problems with Dates but only using Windows XP and runtime. There isn't any references missing as such, but does anyone know if there is a specific date on i can add, just to see if this will solve my problem. I doubt it will work but im running out of ideas!! Thanks in advance.

Date Format Troubles - Please Help!! Im having problems formatting Date() and Now() !! To distribute the application im using Access Runtime 2000. In my code and a text box i use and have used: Format(Now, "dddd") Format(Date, "dddd") Using Windows 2000 my application works fine, however...

Ive got a database by where it copies files and folders from a main folder to another directory. In time the folder will contain more and more files and the copy process will take a longer period of time. Im wanting to put a progress bar on to give the user an idea of how far through the...

Im wanting to write a program by where i can back up files and folders to a location which i specify. Has anyone have any ideas to start me off, or maybe you have already written a similar program. Your thoughts and ideas would be greatly appreciated. Thanks in advance.

Ive imported a text file into a table. The trouble is it has put all the information into one field. There are 3 rows of data with a blank record either side of this. I want to be able to put each seperate row into its own field in a new table. Then i want to delete all blank records. Any...

When i enter a date in Access it keeps changing it to a mm/dd/yyyy format whereas i want it as standard dd/mm/yyyy. My local regional settingas are fine, but in Access they aren't Any ideas anyone!?!? Thanks in advance

Ive got a form with a graphic as a way to exit my application as apposed to a button. When they click the xit button i want a message box to appear saying "Exiting, please wait..." for about 2 seconds then dissapear before the appilication closes down. Is it a wait function?? I havent the...

Im wondering how to store a value on one form so i am able to use that value on other forms. i.e. someone logs on using a custom form and then on the main data input screen it displays who's logged on. Any ideas would be greatly appreciated. Thanks in advance.

We currently have the new office security patch on our servers, when we try to send a task from MS Access we get about 3 messages before this has done. To prevent this we are trying outlook redemption which uses the SafeTaskItem. Everything seems fine bar one little problem, the task wont...

I have a text field which i need to split in a query. I have just converted the query from 97 to 2000 and im getting an error message saying "Undefined function 'Left' in expression". The expression i have is: Test: Left([Field1],4) Any help would be gratefull, as its doing my head in...

In the 'B' column i have a customer number which ranges from 1 to 64, it is a very large spreadsheet. A user wants to be able to select certain customers, which may be random, and puit them into a new workbook so she can email it to certain customers. I need a program written so either the...

When im importing data from excel using either VBA or a macro i occasionally get an error saying: Field 'F1' does not exist in 'TableName'. I dont think this is to do with my data in excel or access as ive tested it with just one bit of info in. My imports work when i do it manually though...

Right, so far i have some code which should loop through every record on my for and send an email until it gets to the end of the file. For some reason it wont move to the next record using rsEmail.MoveNext, if i change this to the docmd.gotorecord,, acnext record then it creates a new one at...

Im trying to validate a number field in VB so the users can only enter either .00, .25, .50, .75 With any number before the decimal space. e.g. if they enter 4.25 nothing happens, however if they enter 4.30 then a msgbox appears. Ive tried all the logical ideas i can think of: <> "*.25"...

I am trying to attach all files in a folder and send them via email using code. I know the hard code to send the actual email, and when specifiying an actual file name i can attach it. Because the file names i want are named differently on various versions of windows i wish to attach all files...

I have a database which emails a task to whoever it is allocated to. This application works fine when using local access, but when i have tried running it as a published application through citrix it generates 2 different errors: One says: "Internal Application Error" The other says: "The...

I have a database set up in access which allows you to create tasks and send them to recipients using VB Code. When sending the task it comes up with this Error Message "The Task "Task Name" is stored as a file, not as an item in an Outlook folder, so the requested action could not be...