Search results

Thank you for your help guys, and yes I can see your point about multiple posts, and my heading was irrelevant - i've taken it on board and I do apologise for not reading it in the first place. Thank you for your post Pat Hartman, I've added the code and it works perfectly - it now saves the...

the link did not work, please can you repost so I know what u mean. I know I've posted this post 3 times, but I was unsure whether the problems related to queries, macros or database design - so I posted in all 3 to cover each angle. Thank you

Hi, I’m using MS Access 2000 – I’ve been building, using and updating an Access database for a while now, and I’ve been living with two problems that are causing problems to its use. The first problem appears minor, but relates to the second problem…. I keep the database in my shared documents...

Hi, When I’m using one of my forms, I need to be able to take the details that are being displayed on the form and save them to a csv file, such as temp.csv, using a command button on the form. Does anyone know if this is possible in Access? There are 23 fields on my [Orders] form, but I...

Thank you for your response ByteMyzer, I've emailed Protx's customer support department asking if they do offer an XML API interface. It's something that I don't have a clue about in complete honesty, but if it's possible then I will certainly be learning it! Thanks for your help Dean

Hi, Any help on this matter would be greatly appreciated as it is a problem that we have been living with for a long time. Heres the problem.... I have an Access database that stores our customers details, aswell as the details of the products that they are ordering from us. We process all...

ITS ALIVE!!!! Bob the code worked, your a legend, you've just cut my data entry time by around 500%!!! Thank you ever so much, I really really really appreciate it!! Yippee!!!:)

Hi Gary, Would you mind taking a look at the post I currently have here - http://www.access-programmers.co.uk/forums/showthread.php?t=129934 It looks like what you are saying would suit, except i couldnt add it from one form to another. It must be taken from another form. Let me explain...

Because of the market I'm in - Outdoor/Garden machinery - my customers don't place regular orders, maybe only once or twice a year, so I have kept the Customers name, address and contact information in the "Orders" table - along with the details of the sale. Although there are ten fields, they...

No problem, thank you very much for your help, I really have appreciated it. If it would not be too much to ask, would you mind taking a look over a post I have just made in the forms forum please to see if you might know what the best solution would be. Thanks again for all your help...

Hi, Would anyone please be able to help me? I've been really really struggling with this problem! I have two forms - the first is my "OrdersForm" where I process my sales information, such as the products being sold on each order and their prices. I have ten sets of fields to allow ten...

Hi guys, firstly a very big thank you for all your help and advice. I took on board what you were saying and the db now runs like a dream. i added an "Quote/Orders" field to the "Orders" table and use queries to seperate the two, and forms to run from these queries. So once again thank you for...

I forgot to mention, the button must be on form1, it cant be sent from form2.

Hi, I'm using Access 2000. I have two forms, Form1 and Form2. Both forms have four identical fields - A, B, C & D. (Form2 is a pop up form and is used to search through and reference records). I want to make my command button ("Importbutton") copy the data in form2's A, B, C, D fields into...

Hi Bob, I can't seem to get the Control Source property to offer the same drop down box of fields from the table as you do, do you know what I'm doing wrong?

Sorry, it appeared too large so i cut it down further, here it is...

Hi Stopher, Firstly thank you very much for taking the time to help me, I really do appreciate the help you and bob have been providing. Looking at this hidded combo box has really excited me, because if I can get it to work then it will solve the original problem I had - being able to display...

KeithG if thats correct you've made me a very happy man, it's 03.26 in the morning here and my brains more than a little cooked - I'm replying very quickly in the hope I could catch you and ask you to elaborate a little... I've googled "webbrowser control" and "access webbrowser control" but...

Hi, I'm using Access 2000. After a very very very long time i've manged to crack my first QBF! When I click the command button to run the macro and display the results, the results are coming up in a table format. Is there any way to have the results of the QBF displayed on the same form...

Hi, I'm using Access 2000. I have a problem... I enter my customer’s information into a form, I then have to copy and paste it into a web-based form. It takes too long to do it while I'm on the phone so I have to get it ready before I call the customer each time. However quite often after its...