Search results

You were right, Paul. I simplified this by just creating a table with columns: ID | Employee | Date | Job | ProductionAmount Thank you very much for pointing me in the right direction and the link. -JC

I think I mislead you a bit. Those tables are not meat for products. They are for employee production. I just posted one production item in both for simplification sake, but they will be: [Production] = Item01, and then in the next columns: Item02, Item03 and so on until 46 items. And this...

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

Look at what the power of meticulous observation can do. I was so sure I had done everything correctly. .... Thank you jdraw, if it weren't for you I'd still be chasing my tail. For other reader I had left out a few "=" sings -JC

Guys, sorry to abuse the goodness of your heart again, but, I tried adding a [Names] group too, following the pattern on the [State] group corrections you made, but I can't seem to find the correct combination. I'm having a "Run-time error 3075" in that particular group. The original State...

Awesome! you guys nail it. I would never have found the solution. My focus was on the parenthesis I placed them everywhere arround that group. Thank you very much!!! -JC

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

I wasn't aware of such a code. It would be nice to have it for future references. And you're right, I just switched every pick list from Value List to Table/Query, much easier now since I just add or edit anything the users want to change in a table. Thanks you very much JHB, oh, and if you...

Is the rowsource for the comboboxes "Table/Query"? Value List, I always use this option. Is the "wrong" result still showing after the form has been closed and open again? Yes it does. What if you do a "Compact & Repair"? Same, in fact I configure all my apps to Compact on Close. ... but now...

Let me explain a little further. I have master file (integrated: front end, and test tables with test data) where all changes to the user interface are made. Then after the changes are tested and approved: 1) The master file is split again 2) The resulting back-end (tables) are...

Thanks you very much for your response, Gina. What I don't see, is the rest of the options I included in a few combo boxes. Ex. [Status] combo box has: "New", "Old", "Refurbished", "Decommissioned" After re-linking the tables the new user interface has the old [Status] combo box options...

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

Thank you Bob it worked exactly the way you suggested here, only thing now is a little awareness for the users no to change the [Status] unless it is really necessary, because, if they change it by mistake there is no turning back or undo. Thanks again :) -JC

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

I think is solved now. In the Column Heading property of the crosstab query I wrote the names of the columns I want shown even without data; "Admin01";"Admin02";"User01";"User02";"User03" Now it is working. There might be a better solution, but right now this one complies. -JC

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

My! By far, I got more than what I asked for. Both you approaches work very good. I thank you guys for you quick and informative answers and I'm going to save both in my knowledge base. -JC

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