Search results for query: *

Hi All I have a problem where I have placed code under an exit button and this makes additional records for data relating to the record that has just been created... All fine and well but if the user has more then one record to enter they can scroll through and not press this button. is there...

Hi AceMan1 I tried to get your one liner to work and I am unsure if it was where I was placing it or just not understanding if it needed to be attached to a field. However after a good nights tossing and turning with this problem rushing through my head I tried refreshing the form (something I...

Hi all I have a Access database that is linked to an SQL database. Due to something I suspect to do with SQL I have the following problem The auto counter field does not push on to the next number unless you move onto a new record. Problem In the form is a button the user can push to add an...

Hi All, I am currently working on a control database for a new PDA report writing system. The Database I am writing is the management side of the system which allows the management to create projects on sites and then allocate staff to visit the sites to audit them. However after a site has...

Thanks Roy

Hi All I have a combo box on a form that contains 3 columns, 2 of these columns are for user information and the 3rd is a reference I require in another field on the form. However I don't know how to tell the field to access that column for the selected value in the combobox. Can someone...

Thanks Ken Works a treat, I don't know why I didn't see it. Have a star Tony

Hi All Is there a way of changing a forms source data collection? When a form is designed you link it to a table or query, what I want to do select a different query depending on which button the user chooses. I know it might sound odd but it should save me alot of replication in form...

Hi All Thanks for your input but I have discovered what was causing it and found a solution. Cause... A field in the table required input of which I was unable to provide (ole object, data will be provided by PDA input) Solution.. Not to access the table directly, by using a select query to...

Yes SQL Sister I have rights to read, write and light the blue touch paper. I have to have full access rights due to designing the gui for the system. About the only thing I can think of is that it might be an old odbc driver on the system controlling the access database (a citrix server)...

Hi Terry, Yes all of the forms I am using have primary keys and relational linking fields. the relationships are also in place between the tables and from what I can see in the SQL Database they are being filled in correctly and should be working fine... But the odbc connection still keeps...

Hi further to this thread I am no longer getting the ODBC error But this has been replaced with a deleted record report.... The record is safe in the SQL database but the access database is showing a deleted record I really am stuck Not the start I hoped for in SQL tony

Hi I have deleted and reconnected the table but still is show an odbc error any further ideas tony

Hi all I am using an Access database as a gui to enter data into an SQL database. Everything is fine except for the following. There is one table that within the access database I can read the tables data and display it correctly within the form but if I go into the table to view the raw data...

Thank you very much drctx That took care of the ability to write to the database but now I get a type mismatch error trying to write to the SQL database. I have listed my code below but I can't see why the select line would throw up this error as it is only selecting data from the database...

Hi All I have an Access 2000 DB that has linked tables to a SQL DB. The SQL DB is active and I can read from the tables ... But. I need to write to and append data to these tables. I have full admin rights to the SQL DB but still can't make any form of data write to it.... Any clues on...

Thanks Loomah Just what I needed to get the job done You are a star but I will give you another to make you shine even brighter Ta Tony

Hi All, I need to read a directory and count the files contained in it. Also I need to read the files names for file processing. Any help you can provided will be very welcome Tony

Hi Guys Thanks for all your help but after turning off everything that will allow the users onto the server then entering a autoclose macro the problem has been solved. Again thanks for all your help Tony

Thanks Roy