Search results
-
W
Create form that will update multiple tables
I have 22 tables that have the exact same structure. Each table represents a customer that has imports and exports. One customers imports may be imports to my company while another customers exports may be imports to my company. We wanted to keep each customer's imports and exports in tact... -
W
Create a table from an Unbound form
May not be using the correct terminology here. I have a form that currently does not have a RecordSource. From this form, I want to create a table called "ICEA" with the following fields (which would be entered from the form): OperatingDay, Hour_Ending, Import, Export, and Net. Can this be... -
W
Create form that will update multiple tables
There is a specific reason that I cannot put them all into the same table. I used "geographic" as an example but that was only an example. -
W
Create form that will update multiple tables
Ok so I read that. Didn't help much. I'm not very stong at all with VBA. How would I get it to see my different table names that are available to be updated? -
W
Create form that will update multiple tables
How do you create a form that is not tied to one single record source? In other words, I want to be able to select the record source that it updates. I have a bunch of tables that have the same data structure but are separated due to geographical nature among other reasons. Is there a way to... -
W
How do you use Dcount in a macro?
I don't understand where you put it. I've got the concept down of how to use it. But how do I incorporate it into a macro without using VBA? -
W
How do you use Dcount in a macro?
I have a macro that runs a query to find Max date of a table, then (I think) I want to use Dcount to see if that date exists on another table. If it does exist, I want the macro to stop processing and display an error message (i.e. "Error with file"). If it doesn't exist, let the macro... -
W
How do you determine if records already exist in a table?
Really all I want to do is take the first record of my import file, use the date field, and scan the table that I want to import it into. If that date exists at all, I want to stop the import. Simple as that. -
W
How do you determine if records already exist in a table?
I have a file that I want to import on a daily basis and append to an existing table in my database. The date changes each day. I want to create a query that checks to see if the date (of the first record) already exists before I import and append the new file. If it does, I want to show a... -
W
Query to determine if records already exist in table
Here is a really stripped down version of my database. Basically the one table I append to and my macro. Also in the zip file is the file I would append from. So how would the macro call the function to run the check and and show a message box if it fails? -
W
Query to determine if records already exist in table
Well this is something I thought of after the fact. My database is built. I have a macro that does the import (this will eventually become a button that you press) which made me start thinking there are no warnings and right now I could potentially import a file more than one time. That's why... -
W
Query to determine if records already exist in table
I don't have anything code wise. But I can post a stripped down version of my database first thing in the morning if that's ok. -
W
Query to determine if records already exist in table
I suppose, but I need someone to walk me through what goes where as I'm not as familiar with code. Could it be a query and then a macro maybe for the error message? I do apologize for my ignorance but I'm still definitely in the learning stage. -
W
Query to determine if records already exist in table
I'm not quite sure what you're saying is what I want to do. I have 2 tables. I want to make sure table #1 has not already been appended to table #2. I can do that by comparing the date from record #1 table #1 to the date field from table #2. If the date from record #1 table #1 exists on... -
W
Query to determine if records already exist in table
Check to see if the first record of the file already exists in the database. -
W
Query to determine if records already exist in table
I have a file that I want to import on a daily basis and append to an existing table in my database. The date changes each day. I want to create a query that checks to see if the date (of the first record) already exists before I import and append the new file. If it does, I want to show a... -
W
Problem with populating form
I'm trying to make what qry50ComparePriMWHtoSecMWH does as a record source. The syntax works in that query. -
W
Problem with populating form
Now I want to combine frmEnterParameters2 with frm02ComparePriMWHtoSecMWH. There's a query that populates the form but I like the way you did it on the last one. I tried to make my record source the same as what my query was but it just didn't work. This is what I tried to make my record... -
W
Problem with populating form
CJ_London, I have a few more questions. 1. On the frm01ATFTieLineCheckout form, I have conditional formatting set up for the "DeltaIn" field. However it's not what I want. I need it to be a percentage (i.e. if the value is > 5% the field hi-lites in yellow). 2. Lets say the form is... -
W
Problem with populating form
This works perfectly. Thank you. Is it ok if I delete the posts where my databases are uploaded?