Search results

HiTech Coach I use the options that come with the wizards when you choose the command button dkinley Will try your code.

I am not sure if I am in the right area to ask this question. In the application I am working on is a Show Program and I need to delete data from 3 tables each year. I can go to Tables, Select All and Delete or I can Create a Delete Query and Run the query and answer yes to the two message boxes...

This seems better method. Just wondered Bob, Your post shows two samples.The second bottom line in each is different. One says TDC and the other FMC. Could you explain. Just realised they are for different versions Access

Thanks will try your suggestion. My application is approx 4MB. It is simply that with the data deleted each year I wanted to tidy up the whole file thinking that it may assist with better performance and possibly reduce errors creeping in.

I have an application in which data is deleted each Year. For example exhibitors entries and fees are deleted. These are removed with a command buttons attached to an update queries. I would like to know if someone could provide some code that could also be attached to another control that would...

Class is a number field

thanks for reply Jal. Maybe I am having trouble explaining what I want but I think Gemma does understand. I have a text box I enter the class number and when I press enter I want consecutive numbers to be written into an adjacent text box. These numbers represent the number of entries associated...

Gemma. I have tried the code use posted but subsitituted my actual field and table names. I have set this up as an On Enter event procedure. The word 'whateverclass' you have given is returning a Compile Error 'Variable not Defined'. As my knowledge of code is limited I am wondering what I have...

I need to maintain the numbers in sequence. Eg Suppose you have a class number assigned to a particular orchid. You make an entry for that class and pressing enter assigns Entry 1 to that class next entry same class assigned Entry 2 and so on. As I said to make this work I must start with 1 in...

I am looking for some code to assist me automatically enter a new number consecutively in a text box. Example. I enter a class number in a text box and when I press enter a query and a macro puts the consecutive exhibit number in the adjacent text box. To get this to work I had to set all the...

Problem solved. Before I read your reply Bob I set up a new database and imported Tables etc and all was working but changed settings in macro as you suggested.Thanks.

Set steps in macro as OpenReport, PrintOut and Close. Have set report name to correct name. This fault is occurring on two different reports.

I can not sort out what my error is. I have a form with a command that is based on a Macro and when I print the report I also get a printout of the form as well. Has anyone any suggestions.

Yes it is a good time to new DB (or did you mean Table).Off for a few days need to look more closely at this when I get home.

Form at present just a separate file outside database till I get what I wanted. Set as a Datasheet. This file is a complete prize list up to approx 560 entries. The sections I mentioned are not separated within this list. Eg the numbers 1 to 50 are for Yorkshire Canaries, 51 to 100 Norwich...

Bob. Have already had pen and paper out looking at altering at least one table. Would like to proceed as follows if that is okay with you. I will try to get something in place to run the code and remove that macro. Also you said in post 42 where one does not need careful entry to avoid...

Bob.Working on Record Deletion setup. Would like to proceed with new form to that would allow easier entry of records. Also should I go back and try to get the code to work from a command button to avoid the Macro. I am going away on Saturday not returning home till Wednesday next week. That...

Done that okay. Yes I want to go to next step however before that, with the code I have I cannot see a way where I am simply deleting an entry from the list. I would have used a query on another Command Button to Open a Table used the record selector to delete record then go back to the code to...

Bob. I have a command button which runs a macro. The macro runs the code which is a module. Does that make sense. I did try to run the code as a an event procedure from On Click But was having trouble. That aside I have re-looked at the requery and am getting "DoCmd.Requery" to work. Yes I was...

Wayne. The main purpose of what I want is to reorganise the Field then renumber the list sequentially. Probably many ways to do this but Magicman was working from a code that I had downloaded and adapted.