Search results

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?

Microsoft's Help System only operates off Microsoft .hlp or .cfm (it might be .chm, i cannot remember). .hlp was the legacy system. It was a help file built using a formatted scripting language (sort of). .chm (or whatever) is the new system. It uses a template style, and actually generates a...

When you built your HLP file, each topic you made should have had a unique Context ID. This is the link to that topic. You enter this ID in the Context field so when it opens your help file, it jumps straight to the topic that relates to the error. If you just want to go to the contents, find...

Did you mean: If you did, the task is simple. Public Sub FormA_OnEnter() If Forms!FormB!txtField <> Null Me!txtMyField = Forms!FormB!txtField End If End Sub

I honestly wouldn't know. This is why I gave you an example of what I, as a summer student find acceptable.

If you're having issues with date formats, the sloppy fix (but works well) is as follows: SELECT *, Day(SeminarDate) as SeminarDay, Month(SeminarDate) as SeminarMonth, Year(SeminarDate) as SeminarYear FROM tblSeminar WHERE SeminarDay = 18 AND SeminarMonth = 2 AND SeminarYear = 2006; It works...