Search results

You best use code. In design mode go to the properties of the checkbox and select the events tab. Create an after update event to set the filter property of the form according to the value of the checkbox. Something like If me.YourCheckbox = True Then me.Filter = "YourDate BETWEEN...

I am confused. Seems like you try to open a form from a report? That's not what reports are for. Reports are for printing data. A usual way of operating is that you have a form with a button to open/print a report. If you want you can select a record on the form to only print that record.

I think you should use AND instead of &.

What error message do you get?

Try quotes around the filter: "[Completion time] =Between #10/1/2022# And #9/30/2023#"

Make a proper database design first. Something like There no use in designing forms when your database is not ok. I am not sure about group and what used to be category.

Wees welkom hier.

While writing mine June7 posted his reaction, which is partly reflected in my design.

I think there are indeed errors in the code if you use in your database (like the name of the combobox is different (Combo30) now). But I also think your table design is not right. In my opinion you should correct the design first before thinking about codes to add records. Here is my suggestion.

So the default value of checkbox is "unchecked"? If so, make a after update event on the checkbox to set the forms FilterOn property to TRUE or FALSE depending on the checkbox value. In form design set it TRUE.

The same seems to apply to UrineR/E tests. So maybe better check whether the second column is Null or not Null? I wonder what to do when the user selects two CBC tests? Then 8 tests will be generated!? A unique index could prevent this, but then you have to deal with the fact that in the course...

No doubt MajP's answer will work. But I advise you re-consider your table design. For example your resource table should be split in (at least) 2 two tables (resource and rate). You don't want to enter the resource name for every year. Tables category and ManageBr should be linked on...

That the user has to press a button to check whether he has filled in a field does not sound very logical. If you had to create a button for all mandatory fields, you would end up with a very strange situation. And what if the user doesn't click the button? You're better off making the field...

IMHO your design is totally wrong. This is Excel not a relational database design. I think your database for a one time survey should look something like: tblQuestionAppliesToCountry discribes which answers apply to a country. You can generate records to the tblAnswer initially based on the...

You can express the "size" of a database in all kinds of quantities. Number of tables, number of records (all tables), number of users, number of changes and probably even more variables. So your question is ambiguous.

Use DateSerial (with fictional day) to convert to date, DateAdd to subtract and Year() and Month te convert to numbers again.

I think you need at least these tables: Book Author Book-Author Copy (inventory no) Domain Publisher If a book can have more than one publisher or domain, you need extra junction tables.

If pWord = "SCtb0825" ?

Please provide values, expected result and actual result.

The real problem here is that the table is not designed correctly. If you can receive several goods under the same code, you need at least two tables. Your solution can cause all sorts of other problems. For example, what if you receive 1 laptop and 2 TVs? Or did you accidentally enter a full...