Search results

Edited. I already created a timer on the form to auto reload and took the reload button away. But is still curious why the error occurred. Hi all. I hope someone can shed some light on an issue that i have. I have a main form that have a query sub form to show some recent checked in data...

Hi all. I'm getting an error when I run the following codes. I have two text field that changes colors on a form based on a subform. I think the problem is when the subform field is blank. I'm getting the error when I navigate on a single form to the next form that have a blank amount in...

Hi all. I have two display forms (in datasheet view) on my dashboard. Form1 and Form2 based on queries, with different two separate tables. Form1 have an ID, DATE, and SUMAMOUNT Form2 have many fields: ID, LINKED, DATE, AMOUNT, STATUS, ...etc I'm trying to highlight the field in FORM1...

Hi all. I have a report that have transactions in the detail sections. Such as date, amount and etc. I have a grand total count at end of the report. Some records does not have any transactions but shows a blank detail section with empty fields. I need the empty fields to show that no...

Hi, I'm a bit stuck and hope someone can help. I have three tables that I am trying to combine the data. I don't need all the data, just some. I'm using three queries. 1st. I have 1 query to sum the total transactions that are over $10,000 based on one Date and the type. 2nd. I have the 2nd...

Hello all. I hope someone can help me with this. I am having problems solving the count employee in the report header and avg of percent calculation. Everything else seems ok. One of my problem is that I can't figure out how to calculate the average of the percent total. I've uploaded my db...

My apologies, I might have placed this in the wrong category. I have a form with some transactions. The fields are ID, BusinessDatetime,businessday,amount,type. Right now I don't have anything in the businessday field. It is blank because I don't know how to capture the date based on what the...

Hi. I hope someone can help. I have a main form that has a list of occupancies. In and Out. I'm trying to get a counter alert on the main form to display Maximun if the manually set maximum is reached based on the total of entries minus outs in one day. I'm not sure where to do this, on the...

I have an inventory table that contains some inventories and a sub table that contains check in and check out records. I'm trying to create a qry that will open a form to show the latest inventories that have been checked out but not checked in. I do have the dates and time of check out with...

Have anyone ran into this issue? I have a form with a subform. Both are viewed in datasheet view. When I set the main datasheet form to no edit, the subfrom (viewed in datasheet view) no longer offers a new record input line. Any ideas? Thanks.

Hello. I hope someone can help. I have a main report and a subreport. I'm having some problems with the query. 1. two tables - employees_tbl and employees_records_tbl 2. 1 query - QRY_employees_by_employees_Begindaterange 3. 2 reports - RPT_Employees_Main and...

Hi i'm new here. looking for help.