Search results

I have started to follow your advice in it's entirety; thanks. I split the data from the forms, queries and reports. I have linked the tables across and everything works fine. I then downloaded the update tool and followed all instructions to the letter. The code does not run unless I convert...

I have just read a similar line and see this as the first solution (the splitting of the system into two parts). As regards your second point. Many of those using the system have their own laptops and it is difficult enough for many of those to find a single location on the one and only network...

I have a database that I have converted into an ACCDE file to help reduce the size of the actual implementation. I am aware that if I want or need to add/edit any forms, queries, tables, etc then I would need to do this to the original source system. My concern is; what if my ACCDE system has...

I agree but I was concerned over the time it could take. However, querying each field would also be lengthy, if not more time consuming so, yes, I will update all fields. Thanks. :o)

I have two tables; one are existing student records and the other contains imported student details. The system already adds new students to the existing records, marks missing students as left but now I have a situation where I need to update records where students have simply had a change of...

I have a form where I want to change the SQL. I built the whole system and have had no issues but now I alter the SQL, click SAVE (or do not bother), try to close the form and I get the Something Has Changed message box with YES, NO and CANCEL. No matter how many times I click YES the form...

I have a central database that exports data I require in the form of an XLS or CSV file. I need to get my database to read in each of the records, check each record to see if it exists and then undertake the following process: If it exists then update any information that has changed If it...

Can I use a pivot table to enter new data to be stored? I have a list of names in a table that I want to have appear horizontally on a form with a blank field beneath them for someone to enter in an idea for each named person. I did read that this would need to use a pivot table but I always...

After posting all my questions this weekend I have now resolved most of the issues through trial, error and lots of blind alleys. I now realise that what I wanted was not a cross-tab query but a pivot table. I have now built the pivot table and embedded it within the primary form with expected...

I want to create a form that cross-references data for the user. The user will get a form that will ask two questions (the one question filters the choices for the second question). The results of these questions then allows a new form to appear that will comprise of the two answers and then a...

Thanks for this: is exactly the issue and now have resolved it. However, I now find that I cannot use the cross-tab in a form and of course even if I could I would need the form to be dynamic since the dataset would change depending upon the choices made. I have to think another way. Oh well...

Can you base a cross-tab query on a select query that requires a parameter? I ask this because I have tried but so far it has failed; raising an error related to the [forms]![formname]![field] statement used in the select query. I know the select query does work and does what I need it to so...

Hi everyone I want to build a form (I know this is the query area but the query is where the error is; I think). The form will give, at the top, the House colour for a school (we have 6 Houses) and then the selected Tutor Group (we have 6 tutor groups per house). This part I have working...

Please ignore this! Never work on a database at the end of a long day and exhausted from a bad week! All sorted out once I'd had a little sleep.

I have created a form with two drop downs. The first is a list of colours and the other a list of teaching groups. The first combo limits the list of the second combo. This all works fine and originally both combos were unbound. However, I want there then to be a control button that opens a...

I can see that Bob. I can't see them changing the structure to that extent since this is a primary key within a system used throughout all schools. Yet, I do agree. There is no need to make the changes since I could include the field as an additional. The issue with changing the data structure...

I can see that Bob. I can't see them changing the structure to that extent since this is a primary key within a system used throughout all schools. Yet, I do agree. There is no need to make the changes since I could include the field as an additional. The issue with changing the data structure...

Sorry Rabbie I started answering the post and then realised that you had posted a response and a question first. However, my laptop went funny and I wanted to go home; not realising that I had clicked on the post button first (makes George's statement look more viable now - doh!). The issue...

Trouble is George; saying that makes me think 'damn you, I'll find out and do it!' simply to spite the implication that I can't do it (I have a touch of SQL coming on). However, I'm going to agree with Gemma (and in turn you George) and re-consider if I need to do this. Considering other...

I have a relational database with a list of students within one table. I now realise that I need to use a student number that pre-exists and it would make maximum sense to use this as the primary key. Currently I have the primary key on an autonumber field. I have over 1200 students and over...