Recent content by ayjayh

Yes, thanks, I have considered those alternatives. It's just that left aligned text would look a lot neater on a form full of buttons. Thanks anyway. Tony

I am using big buttons on my forms and have a lot of text to say what the button does. The text is doggedly centre aligned. Is there a way to left align it? Thanks in advance Tony

I want to swap between any one of four Access databases on my system. I can do this with buttons on a form using "call shell" etc. Is there a way of restricting Access to only a single occurrence, rather than Access opening each time in a new window. I know I can do it from the file menu and...

:) Thanks Rich, That worked fine after I figured out setting the program properties to "close on exit"

Hi all I have a button on my Form which On Click runs an Event Procedure which among other things has a "Call Shell" instruction to run PKpak. PKpak is a DOS program and runs in a DOS window. PKpak then zips up several tables which have just been exported as dbase3 files. (I am using PKpak so...

I've recently come across this problem. I had a form based on a Select query using a single table and all was working fine. I then added a second table to the query and the form stopped working. In design mode I could see everything. The cure was to remove the second table and then reselect the...

Thanks again Rupert, but I don't seem to be able to get the hang of the Module business. However, all is sorted now as I have dumped the Switchboard and constructed my own menu system with lots of lovely buttons to which I can easily attach VBA. I'll catch up with the Module business in due...

Thanks for the reply Rupert and what you say sounds OK except that I can't seem to get my code into a Module! At present it exists as an Event Procedure in the On Click event of a button on one of my Forms. I think if I could manage to insert this into a Module then the rest would fall into...

Beginner needs help again. I have written some vba code to do some external file handling and attached it to a button on a form. This all works fine. However I really need to run this code from a button on my switchboard. I think I need to convert it somehow so I can use the "run code" option on...

Thanks FMM, it works a treat. Once again I am amazed at the response everyone gets from this BB. Tony

Thanks for that very quick reply. Unfortunately you are dealing with a thicko here. When I said I could do the Import bit OK I was thinking of using a macro. The idea of putting inside a bit of VBA code appeals to me so could you elaborate on that for me please. Also, being a thicko, I don't...

I need to be able to import a table (dbase3) from a floppy disc to update a table in Access. To do this I would like to do the following file operations using a macro. 1) check for presence of the file on the floppy (a:\Tillsale.dbf). 2) Import the floppy to Access then update the Access table...

Thanks again Dawn, I now have button that sets a filter to filter only current records (current = True) and another to show removed records (current = false). I am now going to attempt to add a comment to show the date the record was removed. My next problem is a bit more complicated and I will...

Thanks Dawn, I think I'll take your advice and go with your second suggestion. It will be much easier to implement and will make reinstating removed records very easy when/if I have to do it. I don't know the significance of Safeways but perhaps it is best not to enquire. Tony

In my Stock Control projectI have a table called Master and a table called Removed. From a Form based on Master, I want a button to move the current record from Master to Removed, i.e when the button is pressed the current record from Master is appended to Removed and then deleted from Master...