Search results

That does not require you to have 7 fields. It break the rules of normalization and you will be having similar problems to the one you already have. Create a table with just two fields i.e. workID and TravellerID and your data should be stored as follows WorkID1 Traveller1 WorkID1 Traveller2...

you can try to create a recordsetclone and do a recordcount and if it returns 0 then you display your message box

Hi, I think you have a problem with your setup. Could you explain why do you have 7 traveller fields? perhaps a search on normalization would help reconsider your table structure

try Me.Requery

you're welcome, i'm glad that you managed to sorted out :)

Once again a big thank you for you and oumahexi as well :) reputation time :D

The person in question wasn't an end user. Basically some "power users" often create access databases and link them via odbc so that we can create our own queries/reports etc. So what was happening is that the power user in question went to File->Get External Data->Link Tables ->ODBC ... on the...

Hi Banana/Oumahexi, I have created another system dsn and called it sipr and voila the databases are running fine now. Therefore all of the databases are running on all pcs without problems ... the only thing is that all pcs have 2 system dsn now instead of 1. As regards the suggestion to...

not sure if i understood your question correctly, but try adding the word DISTINCT in your SELECT statement of your query i.e. SELECT DISTINCT etc

Hi, I think i found the problem, but before i proceed further i would like to ask for suggestion: I went to the odbc system dsn window and it seems that the pc in question have 2 system dsn created one called sipr and another called sits both having SQL Server as driver. All the other pcs have...

create a form and have two unbound textboxes one for the current data and another for the new data you want to update. Eventually, placed the references of these controls in your query criteria and update to fields i.e. [Forms]![FormName]![TextboxName]. Once you have this setup place a button...

Actually all PCs in question are connected to the same server. In fact all users on pc access the database and perform their routine work. As regards the file DSN, what is basically the difference between it and the system dns? The reason i am asking this is because way back when the database...

well you can do that a form level. Use textboxes to accept the data and then in the query reference the controls of the forms i.e. [Forms]![frmName]![ControlName]

Hi Banana and thanks for the reply. 1) The system is built with Uniface & SQL Server 2) When we setup the ODBC in the control panel we setup a System DNS (SQL Server Driver) 3)Yes we connect via office LAN 4)Immediate window produced ODBC--connection to '|' failed. Thank You

Hi, I normally use Access to link tables via ODBC to a database which resides on the server. I have create some databases to perform certain reports and all of these work fine, however, some of the databases work fine on the pc which were created on but i get an ODBC - connection to 'sipr'...

I'm afraid there are only 5 posters with 5 figure post count, and right now you're placed 5th i.e. last:p

Hi, As already suggested in another thread you can do that with an update query. In the query put the current data in the criteria row and put the new data in the Update to row. When you run the query the data will be updated.

Double Click on query in design view, once you're there from the Query Menu at the top select Update Query.

you can try the update query.

you're welcome :)