Search results

Hello folks. I'm trying to combine/summarize two tables in a query. What I've found so far is that I have to use a union query. I tried that but all I get is punctuation error. So here is what I'm trying to do: tblProdA ------------------------------------ ID | Date |...

About a year ago I created a search form based on Allen Brownes Search model. Working fine, but the user wanted added functionality, see here, after a few tries the users didn’t wanted the option anymore because they were in a hurry to deploy. But now their management is asking again for a...

I have a report that will open by clicking a hyperlink and I want it to open in preview mode. I tried using: "DoCmd.RunCommand (acCmdPrintPreview)" or "Report.CurrentView = 5" in the On Open event but, no success, I only get an error message. I appreciate your comments. -JC

Hello, I'm not sure if this is a Forms problem but since forms elements are impacted I posted it here. I made some changes in the user interface of a spitted DB, a few combo boxes to be specific, and when I re-linked the tables the changes are not applied. I checked the master file to see if...

Hello everyone, I have a "Status" combobox, I'd like the "Date Case Closed" field to auto fill today's date when "Status" combobox = Closed. The way I know how to do this is by using an IIf with Date() function, but, if I do that, the date is gonna keep changing everyday. Do I have options...

In the test db included the report works fine if every Rep (representative or User/Admin) has records assigned. But, for example, if I go to the table and re-assign the first record to another user/admin (pick list in the table field [Rep]), then `User01’ will have no record assigned at all...

I tried searching the forums for a while for similar problems but what I found didn’t help me. One thing I tried was to change Date() for Now(), but no change, same problem occurs. The problem described below was tested as of today 8/27/2014. In subsequent days it might react...

I'm using Allen Browne's search form in an application for demographic purposes. The form is working fine, but the user is asking for a new functionality. He wants at lease 3 state combo boxes so he can filter that [State] field for at lease three choices and the way it is build now he can...

Hello everyone, I’m not sure if my situation belongs to a query’s forum. If I have to post it anywhere else I can gladly do it. I have a situation with a chart/graph. I need to plot a line graph that shows [received] cases vs. [finished] cases. But the [finished] cases have a [status]...

I'm creating a legal form that contains: Case Specifics: Case Number Office Number Court Location Other Part Lawyer Lawyer Phone Number Email Plaintiff Info: Name Address Phone email Defendant Info: Name Address Phone email The tables: tblMain: tblMainCaseID...

I have a demographic (tblMain) table with this fields: - CaseID – AutoNumber - Name – Text - Address – Text - Phone – Text - NotesID – Number (Linked to tblNotes.NotesID) In another table (tblNotes), I have: - NotesID – AutoNumber - Notes – Memo In the Main Form I placed a control...