Recent content by KV_access

Hello, thank you for the suggestion. I have looked in excel and all the relevant columns are set to Currency, as seen here: The linked excel file in access also finds the correction datatype as seen here: So, I am still not sure why the #Num error is there. Is this where you were talking...

Thank you for the suggestions. I haven't attempted to import the csv files yet but I did save the excel as a csv to see if anything "appears" in the apparently blank cells. When I opened the csv in a text editor there is nothing in the cells which appear to be empty which makes the #Num error...

Thank you for the suggestion, I tried it and sadly it didn't seem to work, but I am not sure if I executed it correctly. This was my attempt in the SQL of my query: IIF([Union Query Linked].[Mon reg payment] Is Null, 0, [Union Query Linked].[Mon reg payment]) FROM [Union Query Linked]; Was...

Hello, I have posted a few times in the past week regarding different issues in my access database, but I am finally, hopefully, getting close in my finished result. Long story short I am attempting to create a access database which is linked to multiple excel files (which have the same format...

Sorry for just now getting back, but thank you for all the help. I wasn't aware of how to treat a form versus a subform in this case, so you are right that my code would never have worked. Thank you again though, I was able to get the search filters to work like I had hoped. I am now running...

I have attached the database stripped down to just the forms. Due to how things where linked it won't contain any actual information, but maybe you can see how everything is setup between the Form linked to a Query and the Search Form. Hopefully this will provide enough information to find the...

They probably should be numerical values instead of text fields, but because of how everything was created I believe everything is treated as text. Such as how the Task# Query is being treated below: (Unless I am misunderstanding how it works)

By filter, you just means what the (Ctrl + G) command windows shows right? If so, I tried a couple different combinations of criteria and the print out as follow ([Task#] = "500") AND ([Invoice#] = "7000") AND ([Crew ID] = "400") ([Task#] = "500") AND ([Crew ID] = "400") ([Task#] = "500") AND...

Hello, So, I am still really new to access in general and I am not sure how to figure out why my search form isn't working. I am trying to adapt code from Allen Browne's "Microsoft Access Tips for Serious Users" ser-62 which goes over Search criteria and can be found here...

Thank you for the help, I will have to check more into the ADO method, but I ended up using accesses linked tables. I have posted a couple issues I am having if you happen to have any guidance on them. Thanks again!

Thank you for the help. I have managed to create (using others code, forums, and your help) a macro which looks through a folder and links all excel files with a sheet named "Database" in a access link table. I believe this is a start to what I hope to accomplish, but I am not sure what the best...

Hello, So to start off, I know enough Excel to be little bit dangerous but I know practically nothing about Access. I am trying to learn Access in hope of creating a database which will "search/import" information from multiple excel documents. To lay the groundwork: I will have a separate...