Search results

Any More Ideas I'm still trying to accomplish this task. Tried loops and different queries. No luck yet. thx

Thanks agian, tried that too, to no avail. You need to open the database to really see how it works.

Thanks for your reply! If I sum([fieldname]), since its based on a query, it sums the total of the query instead of just adding the two fields I show in my picture. Give it a try. Thanks again.

Tried wizar, will not work. The first group footer has a control based on a query and I'm trying to sum this on the second group footer. thanks

I'm having troubles with a sum on a report footer. Database and picture attached. Tables where imported from dbaseIV. Thanks for any help. Yes I have search for a solution.

Thanks for the response. I have tried various option, but still no luck. This line of code is duplicated in another database with just a few changes for the - strSQL- and works great. I stop prior to this Set qdf = LocalDB.QueryDefs("qryFilterQuery") to check the strSQl string and it...

Hello: When the program gets to this line of code --- Set qdf = LocalDB.QueryDefs("qryFilterQuery") The program does not update the query definition. The program ends. The query exists, I've checked all the references, all there. The line works okay in a similar program. The qdf is...

Hello: Does any one know where I might locate a free 2d datametrix barcode font to you in access. I tried google, but not having much luck. thx

Hello: I have 15 text boxes on a form. After the last text box is filled in, I can get the average okay, the sum okay, but would like to caculate the difference between the highest and the lowest numbers (Range). I've tried a ton of "If" statments, but did not seem to work. Any ideas would...

Infamous: I'm looking for code to import files like you explain in your first post. " 1. A csv file is imported into a temp table" Do you have a sample of the code you might be able to post to explain this operation. thx dmh

I can't belive no one has an idea on how! You answer the same questions over and over on forms, but I get no response on trying something different. What, can it not be done?

No help or ideas submitted! Is it too complicated to do?

Any other ideas or is it to complex to do. I have search this forum and other forums on programming information for my problem and have not found any idea's. I get bit's and pieces of information, but someone with a little more experience than me should be able to provide some basic code to...

Okay Uncle Gizmo Uncle Gizmo: The database will contain some information, but my customers supply lot of the forms being imported in. I really don't want to recreate close to 1000 plus forms which are unique to each customer. If I do start to create the tables for the forms, what would be...

Each time a person enters a part number into the form they will have an option to pick and load other forms. Looking to have 1 form with a cmd button that when pressed will go out and retrieve an object or objects (spreadsheet, word document and etc) and then place in the OLC’s and rename and...

Thanks raskew The code worked great. Had a few left over that were placed in the tables like 7L24 - 3A719,AG and 7L24, 3a, 719AG. I just edited them manually. The code did not seem to work with combinations or I was using it worng. Thanks again dmh

Just a question on the meaning of " * " [* Regular Booking] What does the * represent in the code? thx

Thanks Thanks for the response, I'll give them a try and I know they will work, because as far as I can tell when reviewing the forum, you answer every question / concern with intelligent and accurate solutions.

I have several Databases with similar tables with similar information, but entered differently. (Different persons made separate databases before my time) I would like to make new tables, write a query to combine the information into these tables, but I need to get the data similar before I...

Okay, now I understand! I wasn't thinking about adding those fields to an additional sub form and then working with that as a separate sub-form. I could have that sub-form just open with the main form and continue to use the controls for the others. Just got in a mindset I needed those fields...