Search results for query: *

I have a field called MktCap which stores numbers (i.e. $250.00). What I would like is a way to associate the number with a text field next to it. To do this, I want Access to look at a table and determine if the value in MktCap(i.e. 250.00) falls in a range of numbers. Depending on the...

I have a spreadsheet that has 10 worksheets (tabs). Seven of these sheets are data repositories that are updated manually. One worksheet will be a summary page that will have all information for these 7 sheets (sans header). As a note, the first two sheets grab certain summary information...

I am creating an Excel-based order entry system. What I need to create is a method that will look up the last 4 characters (file ID number) of the last file modified. This will be displayed on the form and will allow the user to know what ID was used last. First, let me say that I think this...

I am very new to ColdFusion and am trying to learn about its bounds. This is my first foray into database design for a web-based interface so I am unsure about the feasibility of this question. I created an Access database that initially used Access as the front end. One of the functions...

I have created a pop-up form that allows users to select multiple values (Case IDs) and publish a report based on those selected values. This works well, but there is one further need... Within the listbox which holds the selected records, I would like to somehow insert predetermined values to...

I have created a pop-up form that allows users to select multiple values (Case IDs) and publish a report based on those selected values. This works well, but there is one further need... Within the listbox which holds the selected records, I would like to somehow insert predetermined values to...

I have created a search allows users to select a value from either a combo box or a list box. If the user selects a value from the combo box (Category), then they can find all records that match the selected Category or they can select a specific record from the list box (contains all records...

I have a module that allows users to print data to a Word template. As a complication, this action needs to be called from two forms. Normally, this wouldn't be an issue but users can further filter their selected data via an option group, which stores 2 radio buttons (1=Pass, 2=Fail). My...

I have a Qry that is the basis for a word report exported from Access. The concept works, but my difficulty lies in the integration between Access and Word. One of my fields (ID) has a numberic data type (values 1-5), but throughout my database these values are set to other values (1=Pass...

I have created a form that populates a report from values in a listbox. When values are added to the listbox (from another listbox), a number is dynamically assigned to the entry to record the order - so the records are viewed on the report in the order in which the user places them in the form...

I have a form that contains a combobox (holding customer names/ IDs). If the user enters a customer that does not exist or if they want to add a customer, I created a pop-up form that allows them to do this. The form does validate the user's entry but only if it exactly matches a record from...

I have created a form that populates a report from values in a listbox. When values are added to the listbox (from another listbox), a number is dynamically assigned to the entry to record the order - so the records are viewed on the report in the order in which the user places them in the form...

I am trying to create a record count that displays in a textbox. The format I would like is Record 1 of 20, where '1' is the current record and '20' is the record total. The tricky part for me is that I want this to be based on a query that is populated a listbox. My current solution is to...

I have a combo box that lists values. I set its values to 'Limit to List'. I have a button that says 'Add'. This pops up a message about how to add a value to the combo box and then sets focus on the combo box. After the user adds an entry, there is an 'AfterUpdate' that verifies that it is...

I have a Make Table query that I am trying to run. It works fine when I define the table. Here is my code: DoCmd.SetWarnings False DoCmd.RunSQL ("SELECT tcID INTO tbl_cust FROM 1_tbltcMaster WHERE PrintRpt = True") DoCmd.SetWarnings True But, what I really need is the ability to...

As to be expected, I always seem to need the opposite of what Microsoft thinks I need. I have a listbox which filters a report (on Cmd button click). This listbox is populated from another listbox, which gets its contents based on a combo box selection. When adding records from the first...

As to be expected, I always seem to need the opposite of what Microsoft thinks I need. I have a listbox which filters a report (on Cmd button click). This listbox is populated from another listbox, which gets its contents based on a combo box selection. When adding records from the first...

I have created a listbox that will filter a report based on its contents. There are times that I want to further filter the report by only allowing the report to show the listbox contents when their status = 'x'. So, as an example, if there are 3 records in the listbox and I click 'cmdFilter'...

I have a form that creates a filtered report based on user criteria. The users may wish to save the filter (which is a query). My thought is that I should create a temporary table that holds the data that the query retrieves. That way, users can come back later and access the data (in the...

I have created a form that allows users to dynamically filter a report through a listbox. The listbox selections are pushed into a SQL string. This works fine for a limited amount of selections (around 50-60 records). After that, I receive run-time error '2176' ("The setting for this...