Search results

Thank you for your help and I will play with it.

So I am trying to learn how to use Recordsets. So I made a module and then call the module from a report. I also designed an update query to run on the recordset. Below is the code: <code> Function DAOLooping() On Error GoTo ErrorHandler Dim strSQL As String Dim rs As DAO.Recordset...

I would love to do your suggestion, but I am not the one uploading the spreadsheets. I am just the guy who has to organize it once it is in Access. I do not even know where the spreadsheets come from. I was just able to see one so I could write the queries.

I am not sure if this is the right section to ask this question. So here is what I am doing. I am importing an Excel spreadsheet and three columns at times can be missing information depending on what is on the spreadsheet being imported. So the first three columns are type, topic and...

Jdraw, Thanks for the links. I will review them when I get home from work. I think they would not like the idea of me downloading zips on my work pc. While I was waiting for a response I started to look at those type of databases and it appears those are the way to go. So lucky for...

Hello Everyone!! So I have a database and need some design tips on running some queries. It basically works as it collects all raw data from an excel file that is imported. Nothing really makes them unique as a few columns can have different information, but for the most part the same. So here...

Hey everyone, So I was working on a project and I have two queries, but I only want one or the other to run based on a dlookup with another table. So my codes does three IF statements in the beginning. It checks to see if the data has already been inputted. Then it will transfer an...

Hey Guys, Ok I did the following code in a column with other fields selected to view as well. So here is what I have ID (checked to show) TA (checked to show) Final Report Due Date (checked to show) Final Report Sent (checked to show) ColName: IIF(IsNull([Final Report Sent]),[Final Report Due...

Thanks!! Not even sure how I missed that

Hi James!! Thanks for the quick reply, but the code you have listed, where do I put it?

Hello Everybody, I need some assistance with a query for a report. I have googled a few things, but not sure if I am asking for the right thing. I need a report query to check a column for a date. If the date is blank then I need it to take the value from another column. So the one column...

James - thank you for the suggestion and I did discover I was referencing a wrong column. Arnelgp - Thank you very much!! The new code works like a charm!!

Hello Fellow Access Users So I created a new navigation form and want to limit which tabs are enabled based on security level. So I have a table called tbluser and it has the following fields userlogin username security - Admin or User What I would like to happen is if they are an admin have...

Hi CJ and DiS I would like to achieve the same thing as DiS on my navigation form. The problem is I do not know how the tables are laid out to match them. Here is what I have: tbluser: userlogin Username Security - either Admin/Guest I would like to have Admin to have all tabs and then...

Thank you very much for your help! I figured it out and I am an idiot. When entering in the number into the database it added one each time. So it was doing it correctly. I figured it out when I ran it in my test database and compared it. It has been a long day!!

That is correct - what I did to test it was I entered one loan in four times and put the status as Open, Closed, Broken and left one blank. So is my code maybe wrong?

I currently have it searching the loan number and then if it is in an open state within the status column. The status column can have broken, closed or open and when it finds the closed one first it stops and does not report back as a duplicate, but it could be in the database all three times...

Hello Everyone - I have run into an issue with a basic DLookup. The database has grown in size and now we could have multiple entries, but I want it to return a certain one. So the information could be in it three times. Of course DLookup stops after the first one. How do I get it to loop to...

I agree completely with all of you. I broke it apart and with doing so I was able to understand the code and fix my mistake. I have it working now and I am finally done with this project. Thanks everyone!!!

Thank you for the quick response. I went back and double checked and everything is spelled correctly. Thanks