Search results

there is a single box(PSS) containing two machines, pc1 + pc2. both pc1 and pc2 has its own information relating to it, such as IP address/software versions/catalog numbers. the unique fields for the PSS are: PSS ID (number given to single box, as above) (pc1) Workstation name (pc1)...

the key that would tie these two is the ID field, an autonumber created for each field. the ID field is the same in both tables for each record. so in theory i need to say "compare table1's IDField to Table2's IDField and all fields attached to them records to be compared" So (in theory...

thank you for fast response i have since posting talked to a work mate. i have found a way of doing it with current design. its ugly but works. As it needs to be running ASAP i am going to deliver it as is, then go back and change complete structure to how it should be. i've noticed so many...

hello all, two things, firstly, i would like to start my program and go through it step by step using the debugger. from that i can hopefully see what is going wrong and what my variables contain at each point throughout my program. my problem is this: under General of main form i have a...

hello again!! ok, i have run several tests with small sample db's. i have found out what is and isn't happening now. the "find unmatched" ONLY shows you results of records that are completely missing from the other table. what i require is that it checks every field within the record and...

hello, trying to compare two tables from diff db's, i have linked the table from one db into the other db. query is as follows: SELECT [Clients1].[ID], [Clients1].[name], [Clients1].[surname], [Clients1].[address], [Clients1].[hobbies], [Clients1].[age] FROM Clients1 LEFT JOIN Clients ON...

Record linking code problem Private Sub WSIPAddressesOpen_Click() DoCmd.OpenForm "frmWorkStationIPAddresses", acNormal, "", "", acEdit, acWindowNormal [Forms]![frmPSSName]![PSSName] = [Forms]![frmWorkStationIPAddresses]![PSSName] DoCmd.Close acForm, Me.Name End Sub The OnClick event for the...

hello, i have checked out the forum for pevious Q's to this problem and found the below. http://www.access-programmers.co.uk/forums/showthread.php?t=80692&highlight=compare+tables only problem is thats its writen at a bit too technicle a level from where i am. i've done some investigation...

thank you many thanx, code worked like a dream. question which now begs to be asked is "what do all those terms mean. i have a VB book but find no mention of thos "ac" type terms. is there a website with all possible options to choose from etc? also, on "docmd.close acform, me.name" i dont...

Congrats man like to just say well done to you and thank all the moderators here. without you this place wouldn't exist, without this place existing i'd have no answers to my noob questions and without my noob questions answered i'd be knee deep in a book losing hair and cursing the PC to hell...

hello, i have 7 forms, each of which is opened by a main form. on the main form is 7 buttons which should each open a different form. on opening this form the main form should hide/minimise and the opened form should come to the front and be visible. on closing the form the main form should...

on main form i have 6 buttons to take me to different forms. these other forms display different details relating to the same record im looking at on main form. SO, i hit the record navigation button and it flicks to show record 2's details, then i hit my button and it takes me to my new form...

ignore managed to get it done by using the "..." next to rowsource instead of manually typing it in, why it matters i have no idea cos line looks same as mine was but it now works so go figure.

i have a table named "products" with fields "MDateID", "MaintDate", "PSSID", "LogEntry", "UpdatesPerformed", "configurationChange", "comment" i have two combo box's which user selects an entry from the PSSID, then the next comboBox allows them to select the MaintDate for that PSSID choice...

calling m8kwr...beep...beep hehe tried a few different approach's from examples i found. but no no avail. i have two tables + two queries. i still cant get the second combo box to be populated by my choice in combo box 1. once i can achieve that then the next step would be easy. i attach...

bump still looking to resolve this issue, any help much appreciated.

many thanx but still issues remain got an error on runtime. i have attached program for you too take a look. really appreciate this. (and my mate who im doing this for will be even more grateful).

hello, program is ment to take details from a combo box, then from the selection made in the combo box, show details that come from a table in a list box on same form. then from that list box the user picks which record he wants displayed and it populates 4 text fields with relevant record's...