Search results

I have a search form used to search through reservations. One option is to search a range of dates for, say, the client's arrival date. So, you can enter a start date only, and the results will show all reservations with an arrival date >= to that date. If you enter a start and end date, the...

screen shot or current report, and then the pdf is how i would like it to end up more or less

Would anyone at all be willing to help me with this? The above code just reproduces the last item in the list 100 times rather than cycle through the list of records. I want to set a text box equal to this SmartString so display the information. The report is set up right now to have a main...

Here is a question I have been hammering away at for a while but have not come up with an answer yet. I am trying to come up with a way to make a digital archive in addition to the access database that i have been working on. Right now I have records for customers and all of their reservations...

Thanks a lot for the reply, Private Sub Report_Load() Dim TmpArray(100) As String Dim SmartString As String Dim i As Integer Dim iCnt As Integer For i = 1 To 100 If AmenityID = "" Then Exit For TmpArray(i) = DLookup("Amenity", "Amenities", "AmenityID=" & AmenityID) iCnt = i Next For i = 1 To...

the corrected code you posted is giving me syntax error and will not compile

Forgive me, but i am having a problem with the first part too... The Dlookup turns out the correct customer number, but I cannot write it into the entire statement like this: DoCmd.OpenForm "frmCustomersReservations", , , "[CustomerID]=DLookup("CustomerID", "Customers", "ReservationID=" &...

Hi Adam, so if I do that load event for the subform, it will run no matter how I open that form. Sometimes that form will be opened with no filters through the switchboard and start at the beginning. However, if I write in that load event, the filter will filter the reservations even if I am not...

Hey, thanks a lot for the help, I will keep cracking at it. I really appreciate it. -D

Hey Adam, that is a great idea, I wish I thought of it myself... So I have gotten it to work well except for one little case that I thought maybe you could help me with. When I am writing the WHERE conditions, normally the form I am opening has that same field in the parent form. For example...

Hey Adam, thanks a lot for responding, I actually have a lot less experience with VBA/SQL than that code makes it seem. I have a few years experience with other languages so I have been picking it up pretty quick, but ya pretty green still. I have been using a lot of outside sources to get what...

Hello all, So, with the help of some other threads I have successfully created a few search forms. I will focus on just one here even though I will do this for a few different searches. Right now I have a form that has some different unbound text boxes that the user can fill in to search...

Thanks liddlem, I will look into that. In the mean time, if there are any guru's out there reading, feel free to comment! D

Hi All, I have not been able to find this anywhere else so here goes: Let's say I have one table of Providers and child table of Amenities that each provider provides. I am trying to create a report that lists each provider and their dozen or so amenities from the child table, however I would...

Ok Premy, Ignore my last post, I think I figured it out. Thanks very much for the help, I really appreciate it!

Hi Premy, Thanks a lot for the response. That is just what I want, but I am still having some trouble figuring out where I want to put the AfterUpdate info. I have tried a few things but am running into problems. The combo box for countries is no problem, but I am struggling with the rest. Maybe...

Hi Premy, Thanks for the email! I really appreciate it. The method you explained is what I have already implemented for tables like Countries. I had not yet set it up that way for cities and states because I am not sure how some of that works in various countries around the world, but that is...

Hello, this is my first post and should not be a difficult one as I am still a learning novice: I am using Access 2007 My database includes a Table of "providers" located around the world. Each provider obviously has its respective address. To select the country, there is a lookup pointing to...