Search results

Minty that corrected the error, but now its not returning anything when I run the search. Any thoughts. I'm putting the code for the entire form in just in case it might help. Option Compare Database Private Sub cmd_search_Click() Me.Form.Refresh Dim t As String ' Tail Number [af_reg] Dim...

Gina that didn't seem to work. Then again the strHeader variable is not a part of the Reset subroutine.

Gina thanks a million for the suggestion! I was able to make everything work......sort of. I'm still working trough error and or 0 record issues, but I'm making steady progress. Right now I'm scratching my head with this reset. When I open the form and fill in my parameters it returns the...

Hi everyone, many thanks for the help on the last few items. Mistakes and face-palms on my part. This one is truly perplexing me. I have a simple form in which I enter in search parameters to search a particular table. The table is tbl_Log_Pages. Ordinarily I would simply add a control...

Actually the first form is just search parameters that the user can select from. Really doesn't even need a control source, just the right code. As soon as I removed the control source from the form the initial code that I put in worked just find. Now to figure out how to use the WHERE clause...

This is a good point. If I understand the question correctly I think the answer is yes. Both the from being called and the form it is being called from have the same record source "tbl_Log_Pages". Is this what is causing my problem?

The direct answer is yes. And it displays as it is supposed to. Hence my confusion. I did however change the name of the form recently to better reflect its purpose. And before you ask, yes I did make sure that the form name and what is in the VBA matched.

Hi everyone, I have a form that will not open when I call it. DoCmd.OpenForm "frm_Log_Results", acNormal The code looks right but I keep getting a Run Time Error 3008. Something about not being able to open the table programmaticly. The form is a columnar style with a function button...

Never mind, I found my mistake. Thanks for the help that was the solution! :)

June, your Solution doesn't seem to work. This is how I have it typed in 'Change the log page status to closed Me.txt_status.Value = "Closed" As soon as I move away from the line I get the message "Compile Error: Expected list seperator or )" Any Ideas?

Ok I'm stuck. I used a bit of a work around to get the results that I am looking for. I have individually tested these lines of code below. The first two work interdependently, but my attempt at getting them both continues to fail. I either get a "Missing Operator" error or "Expected List...

pbaldy, that code looks great but how do I incorperate that into my Dcount statement? cnt = DCount("[Logpg]", "tbl_Log_Pages", "[disc_date] = #" & q & "/" & " " & "/" & w & "#") in the form txtdate is formatted to mm/dd/yyyy. In the table the disc_date is formatted to mm/dd/yyyy, hence the...

I am totally stuck. I have a query SELECT Count(tbl_Log_Pages.Logpg) AS CountOfLogpg, tbl_Log_Pages.tail, Format([disc_date],"mm"", ""yyyy") AS Expr1 FROM tbl_Log_Pages GROUP BY tbl_Log_Pages.tail, Format([disc_date],"mm"", ""yyyy") HAVING (((tbl_Log_Pages.tail)="N4615W") AND...

JHB! Thanks that was helpful. I'm still missing something though because its not splitting the string. I went back and tried using message boxes to validate and test the separation of the values. The Args(0) seems to return both log page number and tail number as a continuous string then...

I have a project I'm working on and seem to be stuck. I think I'm close but the pass through is not working. I'm working with two forms. Sign off "frm_Sign_Off" and 8130 "frm_8130". The 8130 form is opened by clicking a button. The goal is to auto populate two critical values from the Sign...

Galaxiom, Thanks for the suggestion, that worked. Now I have to solve the other part of my problem which is keeping track of all the requests. So now let me try and put into broad detail what I am trying to do. Working with the same form, here is the goal. (Tried to insert photo but I'm too...

Greetings all, so obviously I am missing something. :banghead: I have a form in which I have placed a sub form table. For the purposes of this post, lets just run with the counting issue. So what I am attempting to do is to have the code count the number of records in the table. Please remember...

Greetings Everyone, My name is Vince, I'm new to the Forum. I am still learning my way around Access, and while I understand things pretty well, I still have a lot to learn. Looking forward to working with everyone.