Search results

It is the same for me. I appreciate SO very much all your suggestions but unfortunately nothing is working so far. @arnelgp Maybe if I go about it another way, really all I need is to be able to select ALL records in the dropdown. The UNION select that I have seen you post about in other...

I do have a date picker on the two date textboxes, I think for our use, it would work much better than a combobox.

Thank you once again. Unfortunately I get zero results when choosing dates but no Uppdragsstallare. I have been messing with trying to add a Union Select in the query behind the combobox to add an <All> choice but while the query itself shows <All> in the list, selecting <All> brings zero...

Could anyone kindly explain to me why the If Not IsNull() does not cover the contingency that no selection is made in the dropdown/combobox? It seems like this is the problem and why it gives no results. Does If Not IsNull() not mean Else ALL Records? If not, then what would refer to All...

Thank you! But this also gives me a Runtime error Missing Operator.

I edited the sWhere to "" but am getting a syntax error with this, possibly this? But not sure how to fix it, getting expected end of statement with() (Me!txtStartDate] edit: sorted, removed ], testing gives me Syntax Error: Syntax error (missing operator) in query expression ' and...

Pat, Thank you so much for your instructions, I am getting to it first thing this morning. In the below code, the string name would be 1=1? If so, the only thing I get in the immediate window is True. I am reading up further to see if I am again doing something wrong. Thanks again for your...

Ok, I am unsure what you mean by string created by the code. I opened the immediate window and ran the code but nothing showed up. I am sorry I don't know how to post/supply you with what you are asking for.

Thank you all. TheDBguy, I was thinking of trying to upload a generic version of my db but it is in another language (Swedish) and it will take quite a lot of changes to make it usable to anyone here, I think. Or am I not considering something? Gasman, I tried three different browsers thinking...

Many apologies but getting a browser error when trying to toggle it as code. I am not sure how to post it. "Oops! We ran into some problems. Oops! We ran into some problems. Please try again later. More error details may be in the browser console." Edit: I don't know if this is allowed but...

Greetings! I have a form with a list of jobs that have dates and agencies attached. On the form, I have a dropdown in order to be able to show all jobs by a single agency. I also have two date range search boxes with a start date and an end date and a button to select all jobs within that date...

Thank you SO much to all of you! I got it working! Have a great evening!

My apologies but the field type for the StoragelocID on the parent table is actually autonumber. Does that change things, Dave?

I did think about using StoragelocName as the ID field. I am a completely self-learning Access user so my knowledge comes from googling and watching online. Anyway, I googled it and it seemed frowned upon so I let the autonumber remain. Would love to remove any unnecessary fields though if that...

Good day, all! I am having a hard time even forming a title for this topic. I was given an excel sheet and asked to create a simple inventory database of it. I cleaned it up and imported it but want to make a parent table of an inventory location. The parent table contains: StoragelocID...

Gasman, the IT dept wont really be of much help if it turns out that is the cause of my issue. The problem is that because of where I work, I just will have to wait for the eventual (I hope) Access update, even if it turns out to be next year, like I fear. It just isn't something I can push...

Thank you so much! Here is a three in one pic that covers it all, I think. The table list, the link manager, and the query you requested. Thank you again!

My apologies again for the delay. I believe you are on to something, isladogs! Here are the messages on my screen while trying to open Access: Wait while Windows configures Microsoft Office Access 2010 (load bar fills and starts over several times, maybe three, then the next window comes)...

My apologies as I am at home now and unable to see the popup windows at the moment. From memory, they are various "loading" screens that look like they are trying to update Access but are failing (because my computer is not connected to the internet). They scroll through four or five boxes and...

A new related question: I have a report based on this filter but for some reason it is not taking the dates into account. The report currently is based on a query with a WHERE clause to match the cboBox for the agency. How would I go about adding the date range WHERE clause? Thank you again!