Search results

Tony, Thank you, I too am int eh uk and need some sleep also. I look forward to your reply Bev

I am happy with the on click event procedure and how to add them, i am not sure what i would add though in order to achive what i wish. I could add the on click event procedure to the same button on the form that invokes the macro.

The only thing that I have in my macro is: DeleteObject (this deletes the table) Transfer Text (brings in the data from CSV File) MsgBox (gives end user a confirmation it has done) That is it. Bev

Thank you for your reply. what i am doing is importing a large ammount of records from an existing CSV file that has been exported from another program. to do this I have created a Macro that clears out my table completely. and then imports from the file on my hard drive. By default when...

Hi, I posted a message in the macros section requesting some help. what I would like to do is change the column names of a table after importing data from an excel CSV file. Rickster57 was kind enought o reply and gave me this bit of code currentdb.TableDefs("table1").Fields("OldFieldName...

Pleasure, I have allready set my report to this but still they do not show? Bev

Rickster, Thank You for this I shall give it a go and see if i can get it working. Regards Bev

quite simply no. when you install an application it puts entries in to many different places and is not just the executable file .EXE because of this you would not be able to copy this to a CD-ROM as it would not work on its own without the other files on the system. Incidently i am sure...

Ok, What you need to do is associate your .APP files to your SIMS programe as the default program for those files. to do this, right mouse click on your .APP file and choose open with. Ensure that you have a tick in the field that says "Alwayse use the selected program to open this kind of...

? Im sorry if I am not getting this straight away. From what you are telling me, I take it that the executable file is on your network? is this correct? If it is on the network then it does not matter about the drive letter of your CD-ROM. providing you create a shotcut that works for...

Keith, Thank you for your reply, I dont suppose there is an example of this anywhere? This is now showing my lack of experience with Access, I have been using this for three years now and there is soo much more i need to learn. Thank You Bev

Hi, I am a little lost? I am confused as to why you are looking for a wildcard for the CD-ROM? You say that the files are located on the network? if this is the case and you create a shortcut on your machine and then copy that same shortcut to another then it would still work. The CD-ROM...

Hi, I have a Macro in my database that is used to clear the contents of a table and then subsequently fill the table from an external CSV file. This is working absolutely great however i would like it to do a little mroe if it is possible? I would like to have it so that after it has finished...

Hi, I have used the code that is available int he code repository to hide my access window. This i have managed to egt working wothout any problems and my forms appear how i wish. The problem i have is that on my forms there are buttons that will run a repost or query. How can i get it so...

Sorted Hi Guys and Gals, My determination has solved the problem. the ammount of hours i have spent on this to find that the solution was so simple in the end.. the criteria i needed to use in my query was: Like "*" & [enter key word] & "*" This then promped my end user...

more info Hi, Just thought i would add a little more info. I have just been playing with the Like function: Like [Find records beginning with:] & "*" Or Is Null This sort of works but the problem that i have with this is that it only displays those records that start...

Hi, I have my Query looking at multiple colums on a single table. The table has approximately 2000 records. I would like to create a Query that searches for criteria in one colum only. I have created a Query and providing i search for exactly what is written then it shows results, e.g. when...

thanx, I will try that and will be back if i get stuck again

the truth is i am not sure of the best way to go with this one? for example in my table i will have two fields that say: field 1 = Bev field 2 = 25 if i am using a form to update this, the intention is that the form will show the two fields with Bev populated and the number blank, i...

i am trying to get a table to automaticaly calculate numbers entered into a field, for example field 3 allready has the number 10 inside it, if i then enter the number 15 i want the field to calculate the existing number with the new number and display 25? currently when i update the field then...