Recent content by Dilbert99

0 i researched the knowledge base for this MS Access error I'm getting, but didn't find the answer i needed. I am using a query to Make a table. When it runs, I get the following error: MS Access error: Cant Add All of the Records in the Updte or Append Query: It set 8 Fields to Null due to a...

Thank you SO much!!! that fixed it! I really appreciate it!

I have a query where i am trying to update field by taking the left number of characters before a space. I'm not very good with Access VBA, so I'm trying to do this via a query. my data is a list of SKUs, where I want to update the same field (sku) with a shorter SKU number, by using the Left$...

Hi Arnel I was designing the form to work as follows: It would be a form that allows for a batch of timecards for an employee to be added. The batch would be timecards for a single employee for a single pay period. TimeCards would be entered for every day that the employee worked during the...

Thank you Arnel! I'll look at it now.

Thank you Arnel. Could you figure out the reason the calculated fields are inconsistently displaying? The calculated fields in the detailed portion of the form (they feed data fields on the underlying table), are triggered by someone entering a PunchOut date value. What is odd, is that the...

I thought it might help if i included an attachment showing the fields on the screen that I'm having a problem with. The calculated fields in the detailed portion of the form (they feed data fields on the underlying table), are triggered by someone entering a PunchOut date value. What is...

Hi, The calculated bound fields for time summary Reg vac sick fields in the detailed form section they are triggered by data entered in the Punchout field

Either one. The one Armel posted would probably be better to use

Hi DBGuy,. Arnel did help, but didn't address the core question. What I can't figure out is: when I enter some codes (e.g. "W" or "M") - the corresponding field immediately populates, whichout moving to the next record. However, if i enter "H", "S", "V", or "B", the form field isn't...

Hi DBguy - did you get a chance to look at my form? I'm really stumped on this one.

thank you very much Arnelgp. I have noticed the "Data Entry" property over the years and thought that meant to Allow Data Entry. I always thought it was ambiguous as a property because there were also Add, Edit, Delete properties, which to me were what allowed"data entry". Now I know that...

Thanks DB Guy. Here's the file. I'm not the best Access db designer. I feel like there may be a better way to design this using subforms. My thought process was to capture the timecards, then using calculated fields on the form, summarize the data for the time and post into a time record that...

I have a timecard input form, where i enter a time code, a punch in time, and a punch out time. There is another form field named TimeDuration which calculates the difference between these times and multiplies x 24. Then, based on the code entered, the corresponding time category field will...

One additional note: The zero factor values aren't an issue because the formulas in the queries don't execute unless the factor is greater than zero. But I appreciate that you don't have the whole picture on the design, even thought the design is admittedly very poor because I am not great at...