Search results

Private Sub Report_Open(Cancel As Integer) Dim intcount As Integer, varFile As Variant, objFileFind As Object hi Fizzio, many thanks for replying.. it is linked to the help you gave me recently with the searching in windows explorer from access.. as you can see below.. I have tried to link...

I am having a headache over this! I have some code which is based on query field, and then populates an unbound txtbox in a report.. I have the code in the onOpen event of the report.. so the report is based on the query.. it opens.. runs the code..grabs the field and populates the new...

Thanks! thanks to you both, I have looked at the threads and the code and it works really well, am going to attempt to complicate it slightly, so may be back with a confused look! many thanks again... john.:p

no it is me also! I am having the same problem... will email Jon and see if he can tell if it is a forum error... thanks john.

ta! many thanks Mile... I had tried a search on the forum, but missed that one.. much appreciated.. John.:)

well, my boss has seemingly asked the impossible, I cannot find a solution but maybe someone can help... I have a an access dbase that stores info about projects... each project is 1 file. in another drive and directory are all the files which make up this final file. does anyone know of a way...

Many Many Thanks. Thanks Pat... that is certainly it.. I did have three tables where 2 were not correct.. I have changed my design and it all works as it should! thanks again.. John.

Well, I am sure my dbase design is to blame for this.. but just cannot see how to solve this.. I have a main table with pupilID as the primary key.. then I have two other tables with their own unique ID as the primary key.. the tables are linked by pupilid.. I am created a multi-table...

TA! thanks to you both.. I knew it was a simple thing, just one of those brain blocking moments!! am very grateful.. John.

many apologies.. I know I have seen this answer on the forum before but have tried and failed to find it in the search. I am sure there is a way to stop a form from showing the last record (i.e the last one which is blank where you add in a new record) does anyone know the option to disable...

Groupwise Admin I used to use groupwise.. so am using my memory here! am not sure that you can create a live link to the address/contacts table. but you can export the contacts table as a .dat file.. and then you could import that into access.. if you goto the contacts screen and I think it is...

Many Many Thanks. Pat & Jack, Many thanks for the help. I could not get the code to work at first, but then realised that the column I was inserting into was in number format and not text! but I sorted that out and the code runs perfectly. Pat. thanks for the combo box idea, I am looking...

is it possible to do the following through VB code.. automate a table to grab the field headings from another table and list them in the first column? ie. table with field headings to be grabbed.. sname, fname, dob, address1, address2 etc. table 2 grabs the field headings and lists them in...

we have just upgraded to access XP, it seems that I now cannot change even the most basic design to a form or a report font, if there are other users on the Dbase... is there any way to override this? in access 97 I was able to make changes with no problem at all regardless of the amount of...

this may be a network/user profile error, but thought I would run it past the forum first.. have just got XP on my machine but when I run the any wizards the options I have are blank.. so for example when I run a command button wizard then the list boxes of what I want the button to do are...

cheers yeah, it is indeed weird, thanks for the help. I have no idea why it is happening, and it did not happen during any type or new install or overhaul, so....! thanks anyway J

this is driving me mad... my access software keeps disabling the wizards, so when I draw a command box for example, I have to code in the action I want it to do, the wizard does not pop up. secondly, and maybe related! on the import table option, I have lost the microsoft excel source file...

tis a strange one.... my department has a dbase which occasionally throws up this error, by rebooting Access or the machine, it solves the problem, and does not resurface... well not on the same machine anyway. I have no idea why it occurs, but I have found no affect on the data it has stored...

Very Very Grateful indeed! many many thanks, I really appreciate the help you have given me, the coding works perfectly now. kind regards John

sorry am sure this is very simple... I have a textbox with a value (txtvalue)... eg 5. this box is updated when the user enter another value in a seperate box (txtentry)... eg 20, the txt value box now will display 20, but I want a running total so it would display 25. then if the user...