Search results

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...

Thanks Bob, it works a treat. On a general point, I am trying to convert my original programs in dbase3 into Access and I think I need to learn VB (or is it VBA?). Can you suggest a good book or other source? Most stuff I read seems to stop short of this. Tony

I have a form to show values in from a table called Master. One of the fields in the table is called TSmin and contains integer values. I need to attach a macro or something to a button so that when I push the button TSmin increases by 1. Sorry to be a Newbie here. All help welcome. Tony

I have constructed a Query form to edit two tables. The main table is a list of items in shipments received from many different suppliers and each shipment received is given a login number. In the Query form I do a Find and Filter by Selection to restrict the data to a particular Log number. I...

Thank you Pat for your informative reply. I had previously tried putting words like "mailing", "address", "label" etc into the Help box and nothing seemed to work until following your reply I entered "Wizard" and hey presto I discovered the existance of the Address Label Wizard. A quick trip to...

Well, not really address labels, but similar. I own a shop and all my products are on a database. At present I use Lotus Approach to print out display tickets showing description of item, price etc. These print out like address labels, e.g. 3 labels across the page & then down etc. I am...