Recent content by ReAn

Thankyou, that's what I was thinking, has hoping it'd be easier, oh well.

I've got a database that I need to import a vacation days table from an excel sheet. The biggest deal with it all is that the excel file & range it needs to search for the data is dynamic, actually I also need to be able to scan different sheets within the excel file. Now, im not new to all...

We all once we're at that phase.

First off, what you're looking for is a JOIN operation in your query. JOIN is a feature of SQL Language that allows you to join two tables on a field. Eg: SELECT Cars.*, Driver.DriverName FROM Cars JOIN Drivers ON Cars.DriverID = Drivers.ID This would return all the colunms of Cars, and add...

Ah yes, I looked into the Eval() Function, the problem arises because the function is part of the Application Object, in turn it's Scope is outside you're function, thus rsTbl dosent exist as far as Eval is concerned.

Can you post the output from debug? Also, you may want to replace "rsTbl![01-yyyy]" with "rsTbl('01-yyyy')" that might help.

Im still not quite clear on the problem. Do you have it like this? Table: Student ID: First Name: Surname: Degree Programme: A123456 John Doe Somethin . . . . . A654321 Jane Doe Somethin else And you use the above query where...

Ok, I see what you're doing. Try this: Function Update_IndDlq_Goal() Dim varRST As String Dim varSelect As Integer Set rsTbl = Nothing If Forms("frm-AgentADD")![cmbDate] = "January" Then varSelect = 0 ElseIf Forms("frm-AgentADD")![cmbDate] = "February" Then varSelect = 1 ElseIf...

Im still parsing that post a bit here but just something i noticed: If Forms("frm-AgentADD")![cmbDate] = "January" Then varRST = "rsTbl.Fields(3)" ElseIf Forms("frm-AgentADD")![cmbDate] = "February" Then varRST = "rsTbl![02-yyyy]" ElseIf Forms("frm-AgentADD")![cmbDate] = "March" Then varRST =...

F2 In the VBA Module will open the object explorer. You can look up function names and methods/properties that each kind of object has.

I love how he asked the question once, and was answered 3 times with the exact same answer ^_^. I guess we all hit post reply at the same time.

Hehe, Thanks. Unfortunately it's hard to find much better w/o a degree. I am currently working on that right now ~_^

Me.frmSubForm.LinkMasterFields = "blah" Me.frmSubForm.LinkChildFields = "blah" frmSubForm is actually the Sub-Form Container, not the form itself.

You can, but you will find it's exponentially easier to just make a quick form.

You have more than one record with the same StudentID?