Search results

Hi, My table has a category field and a status field. Each category can have up to four statuses (open/closed/hold/resolved). I have a query that will provides a breakdown of the table by category and within each category, it lists the total count of each type of status. My dilemma is that...

After several trial and error attempts, I finally have it working. Thanks

HI, I been trying to figure out how to have three combo boxes update two text boxes with no luck. I'm lookin for suggestions/help I have a table that has fields ID (PK); MAJCOM; baseid; base, unit, state, and country. The majcom, base, state and country fields may have duplicates in each...

All, I have modified the call tracker database template to the suite my needs but one issue has arose that I'm seeking inputs on how to handle. I need to have three copies of the database running on three seperate computers (one being the master), all will be at diffferent locations...

VbaInet, Thanks for the info. I'll look into the links you supplied as well. Thanks for the help!

I don't control how the data is entered into the excel worksheets. They come from a myriad of external sources. Here is what I am alluding to; both of these entries, based on the NIIN field, are identical items (the dashes represent column breaks); the Noun field in one record is truncated for...

Hi, I have imported an excel table into access succcefully. The records contain the following fields: NIIN, FSC, SD, NET QTY, NRTS QTY, Credits, Net, and Noun. Each record has a very unique NIIN. I have written a query to find all duplicate NIIN records and sum up fields NET QTY, NRTS QTY...

Thanks. That worked out fine, don't know why I didn't think of that right away. Must be tired.

Hi, Is it possible to call/run a macro from a combobox but it is NOT based on the combobox selection? I know you can do it based on the combobox selection but that is not what I want. I have the user make a selection from the combobox and store it as a variable under the afterupdate...

Thanks for the help. It worked fine.

Darbid, It gives me a compile error message stating that "method or data member not found". While the message box is open, the ".Ipstrfile" is highlighted blue. After clicking OK, "Function LaunchCD (strform as form) as String" is highlighted yellow. I do not wish at this time to open...

I pulled this code off of the MS knowledge database for using the API windows common dialog box to browse/select a file. It works great but it places the file path into a text box. I would like it to store the filepath as a variable for use later on in the database session. Ideas on how...

All, I think I figured out the problem. My security levels were set to aotmatically disable VBA and macros. Changed the setting and now everythign works fine. Thansk for the help, I appreciate it! Hawg1:)

Boblarson, I fixed what you suggested/found. It still dis not work. So I decided to delete the database and start over. Once I created a new database, tables and command button, it all worked OK. However, once I saved the database, closed it and reopened it, it did not work anymore. Any...

Hi, I have been trying to import and excel spreadsheet into access 2007 via a command button with no luck. If I use the external data wizard it imports Ok. Can anyone help me with the code? My source excel file is in the documents folder and is titled 'new wucs'. The destination table...

ML, Thanks for the code. It was exactly what I needed. It helped a lot Hawg1:)

Hi, I'm trying to determine if a check box is checked when I view a record. What is the best way of doing this? I have tried IsNull, but that doesn't seem to work. My goal is to check the checkbox; if unchecked, remind the user to check the box and then resave the record. The...

Thanks for the help but found solution All, Thanks for the help. But some further/deeper research into the forums provided a workable solution to my question.

Hi, I'm trying to use a command button to run a report and save the results to a word document. I am just beginning to dabble in the reports arena and am unsure as to the best way to tackle this operation! My research appears to lead me to using the docmd.OutputTo action but am unsure on...

Karl05, Thanks for the info. That is exactly what I needed.