Search results

That does not seem to work, I have tried that.

How do you set the size of a popup form? Would like it a little bigger than it is coming up.

Thanks Mailman! Working thru it now, took me awhile to think about how to do it but once you said use an append.....that put me back on track.....It will take both append and update queries to do it.... Still would like to know if anyone has code for doing and insert.... I had already...

I have a form and a subform, the subform has a couple of fields. One of the fields in the subform is a combobox. The combobox is called cboletter.....The combobox has A,B,C,D,E,F,G,H,I When a new record is started in the main form I need the subform to start 5 records A,B,C,H,I How do I code...

In this one I tired for a long time to get this down to two forms but when trying to put todays date on working people forms ....date() in a text box would not show...so this one would have three forms and two buttons but does this do what you want. I did it in 97 but could do it in xp or 2000

SELECT Table1.id, Table1.test, Table2.tt, Table2.aa, Table1.ID1 FROM Table1 LEFT JOIN Table2 ON Table1.test = Table2.tt; Table 1 is your A and table 2 is your b you need to in the join properties say you want all records from table 1 and just the records from table 2 where the records are equal

I would build the form on the query and take out Id and Name and instead of using list box combo boxes sometimes are easier to work with I have been working on this but dont have it worked out will try again in a hour

are you sure you want to remove it? Access2000 should always indicate that your trying to open 97 in 2000 and do you want to convert at which point you simple say no and close all 2000 and open the main Access97 and then your file will open in 97, and if you open a 2000 in 97 this time you just...

It might not be the best way but one way would be is that you have a field when the book is check out and you have a field for reserving a book

I believe you do it right after the Select word....... SELECT DISTINCT..........

here is one of mine below: C:\Access97\Office\MSACCESS.EXE /wrkgrp \\TTTTT1\netcount\msacc\development.mdw /user developer and here is another one: C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" /wrkgrp \\TTTTTT\netcount\msacc\development.mdw /user developer looks like your...

are you trying an update query... below I have an update query that is what I think your trying to do is update items on hand when they are receive? UPDATE tblProducts INNER JOIN tblReceive ON tblProducts.ProductID = tblReceive.ProductID SET tblProducts.Unitsonhand =...

Now I understand what your doing. that will make it a thousand time more easier and its the way to go! Sorry Pat, I just was not understanding thanks ;) for responding back.

Staceyed, I am starting to wonder if it would be worth it or not, seem like you may have thousands of records in your second and third tables and if that is the case thats how many update queries you would have to run to reset the relationships after running the 3 append queries and the fact...

I disagree you dont need to worry about the autonumbers that why I said you dont append the autonumbers I have done many queries appending to autonumbers and when you append fields to autonumbers they will just keep on counting Ex:you have two tables with 10 numbers both autonumber fields and...

I was miss understanding but now i know what your trying to do and yes. I would try and do like you want to do. and yes you can do it if your 3 tables have the same fields HSInst HSCont HSSupply COLInst COLCont COLSupply meaning if HSInst matches COLInst HSCont matches COLCont and...

Are you getting close Sue ? I had to remove the attachment because I am heading home if it was helping will add one from home when I get there

first make a copy of your database, Then make a query using the table with bad data field and table with good data field put in critria bad data run query to see if you are match up right if you are then change the query to a update query....when you change the query to an update query its going...

if you can match the bad field with the good field in a query, then you can do an update query....in the update to: under the bad field you put the table name of the [goodtable].[goodfield] then run it but................... make a copy of you db and run a test in the copy until you got it to...

if you Can build a query on all tables and get all data from all tables then you could do a query make table after the table is made then you could do away with the other 5 ids from the other 5 tables or should be able to because they would just be extra fields in your table. but I would...