Search results for query: *

I have a table, Loans. Fields: ID (key) Loan Number Principal Balance. I have another table, Transaction, that's based off the Loan Number field on the loans table. Fields: LoanNumber Payment Type (2 choices, payment and advance) Amount I have a user form where users can specify the...

Ok. This is driving me insane! I have a table, BankData, that lists bank information. It's a pretty simple table, just a primary key, and a bank name. I have several tables that use this bank name as a field. For example, I have an Investments table that uses a bank name field(field name...

Hi. I have some code that I'm using to update a table in a recordset. I have this date function. For j = 1 To 12 Set rst = DB.openrecordset("obligations", dbOpenTable, dbAppendOnly) rst.AddNew If j > 1 Then rst.Fields("DueDate") = CVDate(Str(j) & "/" &...

Ok. I have a doozy of an issue. I have a table, tblobligation. I want my users to be able to make changes to this table (using a form to query the info they need), but before the changes are made, i want the changed information to be added to a stage table. that way,the approver can review the...

Hello. I have a form with several comboboxes. This form will allow users to select whatever criteria they want and print a report using named criteria. The reports are working fine until I decided that I wanted to add an <all> option in the combobox. Here's my combobox, named ItemType. The...

Howdy folks! I tried to search on this one, but it didn't find any applicable info. I have a form with several controls that serve as filter. I managed to fix all of my filter buttons with the exception of this one. I have 2 calendar controls ...I'm trying to filter the data on a date range...

I have this function that updates a table, tblTable with additional fields, etc. That all works fine and dandy. However, I have to check if a code in tblTable matches with a code in tblMaster. That also works fine and dandy. If the code doesn't match in tblTable, I have a form that pops up...

I have a table, tbldata that lists, among other things, name companycode address I have another table, tblmastercompany that lists all the company codes and their corresponding companycode addresses. What I want to be able to do is check tbldata against tblmastercompany and append the...

Hello All. Here's my issue I have a spreadsheet, a portion of which is shown below. All of the columns in the worksheet have an auto filter. I want my analysts to be able to filter any and all of the columns. However, I only want them to be able to edit column c. I want Columns A and B to be...

I would like to hide a tab based on a combo box. my filter is based on a field, fruit. if i filter my records on apples , I want the tabs apple1 and apple2 to be visible (and orange inivisible). if i filter based on oranges, I want the tabs orange to be visible and (apple1 and apple2...

I have a list box that lists the Month, Month Begin Date, and Month End Date in 3 separate columns. The format is as follows: Column count: 3 column width: .6;0;0 The only visible column is that actual month. I would like to use the after update event in this box to pass the value of the...

Help! I have a module that shows how to calculate business days. However, I don't know how to refer to it. I have a table (named ITEMS) with values ID Date Received Date Submitted 1 1/1/2004 2/3/2004 2 2/1/2004 1/31/2004 3...

I need to get the following information in a report. I would like to calculate the number of business days between datereceived and datesubmitted for each . From then, I would like to sum the total date submitted. How can I do all this in a control source for a text box? Here's the table...

Greetings. I am trying to figure out this DCOUNT Issue. I'm trying to (in a report) count the number of items in the item table where the completion field is NOT withdrawn Here's my control source. It's not working. I'm thinking that I can't use the dcount function with a not equals to, but is...

Hello. Is there any way to prevent database conversion? For example, my users are using an Access 97 database, and they only need to use it on Access 97. One my users opened the database using Access 2000, and corrupted the database. Is there a way to check to see what version the database is...

Hello. I have a query, in which i'm trying to select a company number that has the value of 'x'. But since the file specs for this particular field has a text value of 20. I tried using trim for this query, to pick out the spaces, but it isn't working. Help!!! Snoopy92211 This is my query...

I have a form, frmMain, that has the following items. State checkbox and state combobox divisions checkbox and divisions multiselect listbox. The user is supposed to do several things. 1. check the state checkbox and/or division checkbox to see if they want to use that part of the query. 2...

Howdy Folks. I am a relatively new (been in role for 3 months) IT Professional, and have been charged with creating an Access Database (*gulp*)I am very very new to VBA as well as Access. I am trying to create a multi select list box in Access 97. I have a form, frmMain. In that form, I...