Search results

Ok, guys/gals. Here's the situation. I got my cascading combobox working out great. Now how do I use those values in vb to add new records? I.E.: First combobox is the location selection. Second combobox is the fiscal year selection. After that, I want to add new records to that fiscal...

Ok guys/gals, I'm just drawing up a blank today (just got over a cold). My boss want's a report print out of exactly how the structure of the form is. I know it's not a good idea to print forms as a report. What would be the easiest methode to print the form exactly as shown. It also has a...

Ok, I've done alot of searches regarding mailmerge and found this wonderful website http://www.helenfeddema.com/CodeSamples.htm for Importing Access Data into a Word Table. But apparently it is not working for me just to view the outcome of it. Somewhere between the coding of it looking at...

OK, I have this code here: If Me.txtEstimatedDate = Now() Then Me.DateExited = Now() End If I used it under afterupdate under the DateExit field, but it's not working. So I'm taking it that I'm doing something wrong here. I have one field called DateEntered. txtEstimatedDate takes...

I have this code here Private Sub FullName_DblClick(Cancel As Integer) On Error GoTo Err_FullName_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmMemberListMaint" stLinkCriteria = "[ClientID]=" & Me.ClientID DoCmd.OpenForm stDocName, , ...

Here's the situation, I have two tables. 1) Clients and 2) Attendance. I'm trying to create a query to pull names that don't have an attendance record between certain dates. I had try the join types and it seems to not do it. Can this actually been done? I did a testing of a weekend where...

Complex Query not working....Totally Lost now Ok, I'm totally lost now on how to create this in my Query. IIf(Date()<DateAdd("m",1,[DateAssesed]) And [DateVerified]=Null,Yes,No) I'm not sure how or where to put this. If someone can help me out on this, I'll apreciate it. Thank You.

Is there a way to do a dateadd looping? Here's the situations. I have a date of 10/1/03 and want to create a query that will loop it according to current date. I know that if I was using dateadd("m", 2, #10/1/03#) will generate 11/1/03. So in my query it would show something like this...

I really hate being a n00bie at this and I must ask now that I so stuck. I know for any type of monthly payments, I will have to use a query to do this. But now i'm stuck on weather a datepart or datediff or maybe something outrageously different syntax to use to calculate this. I have...

Ok guys/gals, I'm just a newbie here and I'm trying to do some reading on union queries. It seems that if your trying to keep an on-hand balance of inventory that this is the most suggested. I tried doing multiple searches on anything that might relate to both these items but can't seem to...

Hey guys/gals, n00b here with just a quick question. I currently have 3 tables and wondering if having two of tables linking to the same primary key of one table a problem. Then have a form just seperate the two. Here's a quick example Student Info table SSN Name Address Attendance SSN Date...