Search results

- See solution at the bottom Hi all, We have an Access based system that connects to SQL Server 2000 through ODBC. Most of the client PCs use XP, and this all works fine. We recently, however, bought a couple of Win7 PCs and I'm having more than a little trouble setting up the DSN for the...

Hi all, I have a system, which stores customer address/contact information, which I would like to use to bulk email customers. The only issue I'm having at the moment, is that in order to export the information to word for merging I have to right click on the table and select: Export > Merge it...

No, all issues seem to be resolved (touch wood). I had simply got a little panicked when the work around hadn't worked initially. Thanks for all you help.

-Double Edit, both these issues have been fixed with liberal use of DoCmd.RunCommand acCmdSaveRecord Even worse: The new bound forms are giving me "The Data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record"...

I think what I'm going to do is simply make a separate form for each process and have them as bound forms, with the text box bound to the relevant date field. Currently the form uses if statements to figure out which particular field the date should be written to, and then uses the SQL query to...

Thanks for the response. I thought this was probably the case. As the system has only been used in anger for a week, this issue hasn't yet come up (so far the only dates edited have had a DD portion of the date >13). The inbuilt date picker in Access2007 seems to still be producing the same...

Hey again, I'm having issue with an unbound textbox, which sits in an unbound form. Upon clicking the 'Save & Exit' button it is supposed to update the date field in a table (tEvents) with the SQL UPDATE query: stSQL1 = "UPDATE tEvents SET tEvents.Username = " & "'" & Me.txtUsername & "'" & "...

Thanks for the response. I'm using the SQL server driver, version number (2000.85.1132.00). I can't see any obvious way to update this driver, however. I've briefly checked Google, though this turns up nothing obvious. The client OS is XP, server is Windows 2000 Advanced Server. Yes, the...

Hi all, Not sure this is in the correct area, as the issue covers a multitude of areas, but here goes: I have an issue that has started occurring after I upsized my system to run on an SQL backend. I have a form (fMainMenu) which has a textbox (txtDate). The forms also contains seven...

Thanks! I've managed to get the program doing what I need it to now (with the addition of a check to see if the last digit is an X or x, which represents the value 10 in the check digit calculation). I should be able to use the mid() function to do the reverse (convert ISBN13s into ISBN10s)...

Hi all. I'm looking for some help automating the process of converting ISBN10s* to ISBN13s in a book database that I'm currently working on. ISBN13s are pretty much the same as an ISBN10, but are prefaced with 978 and, here's the rub, the last digit is a check digit that is dynamically...

Thanks, that seems to have worked a treat - and saved me an innevitable headache some months down the road.

Hi all. I'm having a little issue with a multi-selection list box in a form which references a table (tCustomers) and determines what values are to be copied to a temporary table upon the clicking of a button. I have all the code up and running, and all seems good. However a little testing...

Ah, that simple eh? Now don't I feel the goober. Thanks.

Hi all (again), I have another small issue that, hopefully, should be as simple to resolve as the last one. I have a form which contains a list box (list20), and two buttons. The first button (add/edit), when clicked, opens a form which either displays the data for the item selected in the...

Thanks, that seems to have worked a treat. Would have never have thought it would have been something so simple. Thanks again.

Hi, I hope you might be able to help me with a little issue I’m having with an order processing system I’m trying to put together Firstly a little info about what I’m trying to achieve: I have a form which lists products within an order, and I’m currently trying to write some code that...