Search results

What would be the code to copy a table over to the backend...??? I have figured out the code to add fields to an existing table, but not joy with the other..

Hi All, I'm trying to figure out how to create a table in the linked BE of my DB if it doesn't exist, i have tried several methods but i am still having difficulty working this out. Any Help or samples would be appreciated.

Bump!! any ideas anyone!! need help

Hi all it's been a while since i was on here, and also a while since i was playing with access. However i have a problem which i need some help with. Firstly i have a form which has 2 list boxes on it. On the listbox1 you can double click an output format which then appears on listbox2, what i...

Hi All, still having major snags with this problem, had a look at the examples as suggested but with my lack of knowledge not having much luck. any more help would be appreciated. Thanks in advance

Can Anyone Offer some help with this problem PLEEEEASE!!!. Don't know where to turn with this anymore!! Searched loads of different threads and can't see the wood for the trees. Thanks in advance

BUMP!! Does anyone have an answer for this problem

Doc-Man That's all very well if you are used to using access. I know that this subject has been covered several times and have seen some of the ways in which people have updated their databases. This however doesn't help me in my search for an answer to my problem. If it was that simple i would...

hi colin, thanks for the response. The listbox sounds like a great idea. as stated in previous post to FatD, i'm not the best programmer so implimenting things aren't as easy as writing them down. I'll have a look tonight and see how i do. Thanks again

Thanks FatD, i'd already had a look at this site plus plenty of others and still have not come up with a solution to the problem. I'm not exactly the best programmer in the world and have been trying to solve this now for what seems like an eternity. Regards

I need some help on a problem that has been bugging me for the past 4 months, everywhere i turn i cannot get help for this. I have a DB for stores maintainance and what i have is a form on which stores are ordered. What i need is a way of accounting for the stores as they arrive and adding the...

Sort of, I have a table already on which the orders are created, however when the order is printed this table is then cleared to allow for new orders. What i would like is a second table, on this the order would be created with a order ref no. Then using a separate form maybe called 'Items on...

Can Anyone offer any help on this problem. I'm going stir crazy with this and don't know how much more i can do!! Regards 1E1V

2 Tables I thought by opening 2 recordsets you could write to 2 tables, the table one isn't a temporary table it exists for the purpose of ordering stock, as said before once the order has been placed then then table is cleared. Don't know if this is the easiest way but that's how it's done at...

OnOrder Table Hi Neileg, I understand it's not good practice to move data from one table to another, however i think you misunderstood, the data isn't actually being moved, What i want is to write to 2 tables at the same time. 1 table would then be cleared at the time of exiting from the form...

Hi all, haven't been on in a while but really need help with a part of my DB, i have a table on which orders are placed, once the user prints the order form the table is cleared. However what i would like to do is duplicate this order into another table with an Order Ref Number,and then using a...

As long as you can guarantee that these tapes will have all the information your require so that if the backend becomes corrupt or the server fails then no. however it may be best to have a failsafe. My BE also resides on a server of which is backed up everyday, but i still placed a backup...

Try This code on the onclick function of your button Dim MyApp As Object Set MyApp = GetObject(""C:\Yourfolder\YourFile.xls") With MyApp .Application.Visible = True .Parent.Windows(1).Visible = True End With

What a Star Asentry, Well what can i say what a star, the Combo Box example was exactly what i was looking for, i have now implimented this into my DB and all is working well. Many Thanks for the help. Regards 1E1V

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending...