Search results

I will definitely use the code box from now on. Sorry about that. Also, with the concatenation of the *'s will this line actually give me what I am looking for? Bringing back the current Client_ID with data before or after it.

I have a relatively complex query that I have built (it is pulling information for calculated fields from roughly 30 other queries that were created to make calculated fields) and one thing is really causing me problems. We have clients, but some clients are split into 2 clients (Client and...

Thanks you for the advice. I actually took a look at the links you had posted already and was trying to think of how to use them. This seems to be the way to go. Thanks again for the help.

I'm not sure how to do it in Access, but you could export all of the original information into Excel again and fix the typos there or combine the information as you see fit. You could then import the data back into Access.

Calculated field issue dealing with other queries Here's the deal. In my continuing quest to replicate my company's fee structure in an Access database (to create a query to spit out the information they need in the format they need it in) I have run across numerous exceptions which have...

FEES: [Fees]+Nz([Brokerage_Fees],0) Something like this in the Field: section right? This seemed to work, but I'm not exactly sure if this is what I was supposed to do. EDIT: That seemed to work perfectly. The numbers match up to what I did by hand so everything looks good. Thanks again for...

It is currently in the Field: section of the query design. I wasn't sure if I needed to create VBA for it or not.

Sorry for the confusion over that. I am not exactly sure where to put this code. Do I create a module in the visual basic editor or add it into the SQL or...? Sorry if this is a stupid question, I've never dealt with a problem quite like this.

I now seem to have another problem with this issue. FEES is a calculated field. It is pulling in calculated "fee" fields from 5 separate queries. There will be FEES for every single client, but the inclusion of the other types of supporting "fees" (of which FEES is made up) will vary, thus the...

You sir are a genius, both for knowing the answer and for being able to follow what must surely be a convoluted initial post. That worked perfectly. Thank you very much for you help.

If/When (most likely when) this becomes way to complicated to understand please feel free to ask for clarification. I am unable to put any code or databases on here as of yet due to permission issues at my place of business. Here's the deal...I'm creating a database for my company. The database...

That worked perfectly. I am getting an Error 3022, but this is just because I hastily threw this together (the form) and the controls are not set right for it to do it right. I am trying to allow duplicates where I can't so I can just change that. Sorry about the edits. I hurried a bit too...

I was missing a & before me.txtPopulate. Now I don't get either of the errors, but nothing is happening when I hit Submit. I need to add code to open a new record upon hitting the Submit button, but am I missing anything else. Nothing is showing up in the tables when I hit the button. I am...

I have 2 unbound controls. 1 combo box and 1 textbox. The combo box is comboID and the textbox is txtPopulate. I want to send this information to 2 different fields in a table in the current database. This is the code that I have and for some reason I keep getting an "end of statement...

I am taking my time with my decision, but it is really difficult. They expect me to learn how to use unbound controls, send data (input) from an unbound control to a field in a table and learn all of the new ways to do error checking by the end of today (4 hours from right now actually). This is...

I agree with everything you have just said, which I think we agreed on before (lol). My bosses just want it unbound. Aboslutely everything should be unbound now. I am an intern and was extremely proud of what I gave them today, but the first things they said after 2 minutes of use was "we are...

Dim db As DAO.Database This results in an error. Compile Error: User defined typed not defined. Apparently Database does not exist like Recordset does. Do I need to write specific code declaring it as a type of variable?

Yeah, but...how DO you open a recordset on the data. I have never done this. This is what I have and it gives me the your blah blah does not match the specified blah blah procedure yada yada yada. Option Compare Database Private Sub btnSubmit_Click() Dim rst As ADODB.Recordset Set...

I'm not being paid to learn this. I'm being paid to do other stuff while still trying to find some time to work on this. If this was an IT internship I wouldn't care, but it's not. It's an accounting internship where my assistance was requested with this on top of my other duties.