Search results

Thanks in advance for help with this query - I'm stumped. I have a table of account numbers that has other columns, including "name" and "status". The status basically has two values - "subscriber" and "user" - basically, who is using the account and who pays for the account. Where the...

Hi all, I'm just wondering if anyone has had success using an Adobe form to collect data, and then import that data into Access? I was looking at/hoping to use XML. Essentially, I have a need to collect data "off network" and then import it into Access, and wonder if Adobe is the best place to...

I have a database where I track department and personnel data, and from which I print a twice-yearly directory in PDF as a snapshot of both people and departments. The data is updated regularly, and the PDF is primarily used as a reference for where people were at given times, as assignments...

I have a table with seven bit fields, and I want to select the records where the total of all the bit fields is greater than 3. Is this possible? Thanks.

Hi, I have a table with seven boolean fields: I need to count all the "trues" and return the row if the sum of the trues is greater than 3.... and I am not sure how to do this. Any thoughts? Thanks!

Hi everyone. I have a report where I read the value of a field in my query (a boolean) field, and if the value is true, I display two lines on my report, hide the lines if the value is false. Here's the code: Private Sub Report_Page() If Me.Flagged.Value = True Then...

Hi, I have an Excel Spreadsheet (2010) with 50K+ rows that has transaction information for individuals. I have DOB, unique ID, and transaction information in the columns. For each person, I may have dozens/hundreds of entries. What I would like to do is count how many persons I have using...

I have a document that, based on a user selection from a combobox, I'd like to put a specific note in the footer. The combobox is on the first page of a multi-page document, and I'd like a notice to appear on each page, and the footer would work well. While I am fairly comfortable with VBA in...

Hi there, I have a two-column table in word, where column one is a static label and column 2 can have 4 values - High, Low, Medium and Nil. What I'd like to do is format the background colour of the cell after the value is entered. I'm fairly handy with VBA in Access, but am a complete newb...

I'm new to the website game, but have built several static brochure-type sites and recently my first data-driven asp site. It works well, but I have no idea how to get search engines to index the data that's in the database. For example, if someone googles an item that matches an item in my...

Greetings all: I have a database tracking customers and inventory, and I've tried to add in a feature where I can meet customers needs with future inventory. Key to this process is three tables: tblCustomer - containing my customer information tblInventory - with inventory data including a...

Greetings, I am trying to write a parameter query ... I have multiple fields the users *could* search, but they may want to search only one, and I am having a struggle figuring this out. Ex. fields to search are Gender, Age, Date, etc., and I have created a parameter query that includes...

Greetings: I have a database where I collect photos of items, and text of said items. The photos are not stored in the database as OLE objects, but are linked to a record and stored in a separate folder. This is working well. My challenge is: every so often, a set of my records are displayed...

Hi folks, I've searched through the forums and found a little on tab controls, but haven't been able to figure out what I am trying to do. I have a form with mutliple tabs, each of which contains a subform related to the form on the first tab. When I am scrolling through the records, I might...

Hi folks, I am trying to update a field that contains position number information. Position numbers are 8 characters (all numbers) and begin with either two or three zeros as placeholders. When I update the field, the preceeding zeros are all dropped. Here's the bit of code I use: Dim...

Greetings: I have developed a database that is mostly working -- in Access2000 running on W2K. The database allows users to select a vehicle from a pool and book that vehicle for certain dates. The issue I have is with the date settings and the regional settings on the computers. About 40 of...

Hi Folks, and I apologise -- there have been a plethora of posts on this topic, most of which I have read, but I still have a question: I have a database where I want to track vehicle use, and I have 6 vehicles that can be used for any of 15 people. When a person wants a vehicle, they go to...

Greetings all, I've had a similar problem before and posted to this forum, but have rediscovered this problem. I am updating records from a form; on the form I have a text box called txtRemarks which writes to a Memo field in the database. This is the code that I use to write the query: Dim...

How can I tell which form is open programmatically? I have a form used to update records - and these records can be accessed from one of two forms. After the update process has run in my code, I want to send the user back to the form from which they came - but I don't know how to identify...

I am trying to check the value on a check box that corresponds to another checkbox on the same form. Here is the code I am using: With Me .chkNewIndefinite.SetFocus .chkNewIndefinite.TripleState = True If .chkNewIndefinite = Null Then...