Recent content by cbkebasen

Yes I will. Regarding the field type, the column is a calculated field (datediff) and format in general number.

I'm not in the office right now so I'm sorry I can't post the query string, so I'll post on memory. The form has a more than 5 criteria fields; but it was designed to show all records even if none of them are filled. I'm not sure if I remember correctly, but here's the general code for a...

Dear All, I've seen a QbF query that is active but the TS has a different question so I don't want to derail his thread, so apologies if I make another thread regarding QbF. Anyway, here's my problem. I have a query with a column that returns number of days per record. Using a form, I can...

Hello Everyone, I have a form which basically is composed of charts and graphs whose details are fed by queries. The form is in ACCDE format distributed to users and the tables are hosted in our company Sharepoint (2013). Now sometimes when the form is already open, charts loaded, an error...

I have a database linked to Sharepoint lists. My forms are working perfectly until after I made some changes to the sharepoint list and re-linked the database to these lists. After the re-link, the buttons on my forms are not firing anymore despite checking the events code and compiling the...

I was able to figure this one out, thank you for your lead. However, my main problem still exists: The blank fields still don't appear on the print-out of the report. I've tried putting words if the source is blank and it does appear upon opening the report, but a different story when it is...

hello, i'm glad i've passed through here because this is exactly the problem I am facing right now. I also do want my report to show all fields even if they are blank. I did try the solutions posted above but the formula still shows circular reference.... any more possible solutions?

Tried this one and the idea works as we envisioned it. Thank you so much! You just saved tons of our time!

Thank you for your reply. No offense meant, but this unfortunately is pretty similar to what we are doing right now in our form (the data encoder selects the ward, then puts the census for that ward; then moves on to select the next ward, and put the census for this ward... until 20 wards have...

Thank you for the advice. We will correct this one ASAP. Yes, information will be entered for all the wards everyday (even if the census is "0"). Maybe good to start with what you have in mind?

I have a table being filled everyday that contains the following: ID EntryDate Ward_ID (linked to the Wards table) Census At present, the data encoder manually chooses the ward via drop-down list to identify the ward, and fill the census field. Since we have 20 wards, we find this exercise...

Thank you Mr. B for the idea, at least you've pointed me to a great direction. I have little knowledge of VBA, so I'm gonna research on how to do this. I'd appreciate it greatly if you can advise me further. Again, thanks!

Hello. I hope someone here has had experience designing forms based on the following: I have a table that is populated everyday, with following columns: 1. ward (linked to the wards table) 2. date 3. number of patients We have a total of 18 wards, wherein the daily number of patient in each...

@Roku, the codes worked beautifully. much thanks!

Hello Roku, thanks for the quick reply. Basically I also want to perform the same test that I do with the other combo boxes- which is to make sure that required combo boxes (multi valued included) are filled out before update. The same goes to the multi value list boxes. cheers.