Search results

Well, here's the situation. I have to combo boxes and one list box. Once the two combo boxes filter what I need, the combo boxes bring up a list of tickets. What I like to do is add additional tickets to that fiscal year. I have it setup that I can view/edit a specific ticket with a double...

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...

Sweet! Sweet...that's what I was looking for. Thank you very much.

ok, I got that much but...... Ok, feeling a little bit better today. Pat, I know I got that much, but how would I use my current form that I'm viewing as my source for the data to print to the report?

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...

Pat, that's what is needed to kind of self automate. Even if they don't go into that record they can still see it from a query and it will be a reminder to the user to go into that record to double check on the recorder before closing it out.

Nevermind, I got it to work.

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, got it. Actually, I used Onload and it work perfectly.

Wait, I got it......I had to tab to the field and then it stamped it. Hmm would this work if I used upon opening the form?

hmmm. Still doesn't stamp the field with that date. Should it be under Afterupdate?

I'm using this DateAdd("d",90,[DateEntered])

Ok, I changed it to =date(), but when I did that, it changed it to =date.

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...

wOo HoO! Thanx. Work great!

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, , ...

That work B-e-a-utiful. Thank you very much.

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...

OMG!!!! I was thinking so wrong on my criteria's...LOL It's actually like this Field: [DateVerified] Table: tbl Criteria: is not null Field: Dateadd("m",1,[DateAssessed]) Criteria: or: >=Date() A descripition of what this does. I have an attendance sheet. When the people have been...

Date() < DateAdd("m",1,[DateAssesed]) And [DateVerified] Is Null Seems not work work properly. Is there a field name from one of my tables that I need to put this in?