Search results

So, I would have a table of Tasks, (TASK_ID, TASK NAME) a Table of Clients (Client_ID, Client Name) and then a joined table like, (Result_ID, TASK_ID, Task_Name, VALUE, Client_ID) That makes sense, why i could not see that before, i dont know! Just need to workout how i build the form, using...

Hi Stopher how would you then use that tick list for 100+ clients? They way you have it set out would suggest it can only be ticked once OR you have a column for each client, adding 100s of columns is going to get messy? You are right, its a tick list type thing, where i have all the Tickables...

Hi Guys, I have a table that feeds a form, the table is a list of things that could be required for input in to a system based on client request. Lets call it "Detail" Client ID | Client Name | Profile | Image attached | and so on. The data in these columns, is not really for anything other...

You said to have the Before and After Events on the Customer Form, so i did. Before Insert | glbCustID=ID After Insert | currentdb.execute("INSERT INTO tblTech (CustID) VALUES (" & gblCustID & ")") forms![Customer_Form]![CustBox].requery forms![Customer_Form]![CustBox]=gblCustID (Its not a...

Ok, I see what you have said but i must be missing something, When its in there and i try to type in a new Rec. it says invalid use of null, as the ID number is still null until i finish entering the Customer name? (thank you for your help!) UPDATE: can I add an ONLOAD that forces the new...

Can i check where i am creating this Module, i thought here: But access says it cant see it?

My only possible issue with that, is that not all Customers have a Tech report, some have other things depending on their Type. If i combined the other 6 tables that hang off the Cust one, i would have about 250 columns on that one table and a lot of blank cells.. My whole database hangs off...

Ill read into Subforms.. Have not used them before.

The ID on the Table "Customer Record" is an autonumber, its the PK. The FK to this number is Cust_number on the other table "Technical Details" No, there would only be 1 Tech record for each Cust Rec. so 1 to 1. I am sorry i am confusing, I struggle with the way Access does things.. :-)

How would it Auto append to the Technical Information table? Via the relationship? So how the database works, When you open, there is a ComboBox that is populated by the Customer Table. You choose a customer and press open (a button) that opens the Customer Details form, based on the IDs...

Hi CJ, In my actual VBA/ACCESS i never have Space, everything is "_". I am just rubbish in forums! ok, so ID is the Autonumber ID on the Customer_Table, so Customer A = ID 1 on the Technical Information Table, under column CUST_ID would be a 1 for Customer A, so that it relates back, right...

Hi, I have a first form, "Customer Details" This links to 2 tables, Customer Info and Contacts. on this form is a button that opens a second form Technical Information The table for this form has the ID of the Customer details form in colum CUST_ID. I thought i would do a VBA button...

What a spanner I am! Wood for trees I tell you! I have added in the missing code, For RD = Wks.Range("AL" & Wks.Rows.Count).End(-4162).Row To 2 Step -1 It seems to be working well now. thanks for your help!

er.. yer, I have got that from another forum and if i am utterly honest, have no idea what the numbers do. The XLUP makes sense, but the numbers not so much!

Why (-4162) and not XLUP? Thanks,

***JUST SEEN A REPLY** so Edited Ok, i did a bit more reading and I now have this: Private Function WipeExcel_Optional() Dim FN As String Dim LN As String Dim UN As String FN = "VOD Ops " LN = " Schedule.xlsx" If IsNull(Me.Combo1) = True Then MsgBox "Choose a User", vbOKOnly +...

Thanks guys, having read through your advice, i have changed my SET to now have the worksheet and the sheet name etc.. this has improved things. What i am unsure about is how to correct the reference line, For RD = MissingReference.Range("AL" & MissingReference.Rows.Count).End(-4162).Row...

Hi I am a little confused, I do set the object, Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True The RANGE is looking at the whole of column "LA" and then deleting Rows where the string test is true. Thanks for the link, ill look through it, :-)

Hi all, I have a function that works sometimes, but other times gives me an error. "Run-time error '1004 Method 'Rows' of object'_Global' Failed" My function, opens Excel and then erases all the rows that meet a string value in a cell. when is does work, it has this habit of making a hand...

Thank you for that, its good to know how that works! Have a great day.