Search results

Thanks for sharing the link but it did not help with my issue. The link mentioned the following 6 areas, i have added my comments particular to my case. In an Excel spreadsheet presence of an excessive number of columns. I checked. no extra columns. in the first place, the excel file were...

I still can't figure out what is wrong. I have attached the files here in a zip for anyone to look. Description of files: 1) Test Planner - tables loaded. This is the original database 2) Test Planner - Blank created from template. I took file #1, saved as a template and created a new database...

now that you mention it, yes. the fields for one of the columns (remarks/description) are blank

xlsx

So I'm trying to reset my database. So I exported most of the tables. Then I saved the database as a template and created a new database based on the template. When I try to import the (exported) tables back in, some of the tables imported in with no issue, but some of them failed with the...

update. I "compacted and repair the database" and the query in the main database worked as it should! i'm not sure why. but i'm thankful nonetheless. thanks to all who helped by looking at this thread.

strange, it doesn't work in my main database. either it overwrites an existing row. or MS Access will return an error that it is not able to append the row due to key violation.

oops, in my tiredness, i forgot to attach the file. done.

Hi everyone, For my database, I have a append query which takes all the rows from Temp_Table (except the primary key field) and appends it to the main table (Task_Detail_Table). What I discover is that it does not add the rows as new records to the main table but overwrites existing rows...

Dear June7, Thanks so much! It worked now. It was previously set at 2 and 0",1" respectively.

the field is currently blank at the moment, so the field is NULL? it can't be a ZLS since it is a number? right?

noted. will remove numerals from now on. but even after renaming it without the "1", the above still didn't work.

as explained in the original post, the Analytical method has a default duration. So the Bio test usually takes 100mins for example. But after assigning the task to an analyst, in real time, things can happen and the actual duration may differ from the typical duration. Say for example, the...

In the row source query for the 1cboAnalyticalMethod control (in the Task_Detail_Add form), I added the Duration_of_test field from the Analytical_Method table as the fourth column (from the left). I unchecked the Show box. In the AfterUpdate event of the 1cboAnalyticcalMethod combo control, I...

thanks!

which combobox should I put the above in, the combobox where I make my selection of Analytical Method? What does "Me" refer to? Do I need to change it to something else specific to my database, or is it a keyword in VBA?

[apologies that i posted this in Reports instead of Forms by mistake. But I do not know how to move or delete this thread.] Hi everyone, But before I describe the Current Issue, let me describe my database first (attached). (note: dummy data is fed into this database) Tables...

thanks! i see how using a second query that references the first can achieve this.

Dear Pat, Thanks. I get what you are saying. I'll give it a try.

thanks for the warning. i'll keep that in mind.