Search results for query: *

I've created a worksheet (Excel 2K) and preselected a range of cells populated with formulas and formatting that I need. I did this so that I could have the user fill in data using an access form however the input from the form won't allow the list to grow without losing my formatting etc. As...

Is it possible to use a single Access form to edit data in multiple Excel worksheets in the same workbook? Like using a dropdown combo box to select which sheet the user wants to work with? Mike

I've built an Excel 2K sheet and linked an Access (also 2000) form for the user to add/edit records. The problem is in getting Excel to autofill the formulas for each new record using the Access form. If I enter data directly into the Excel sheet it works fine. Do I have to manually fill the...

It ain't happenin', folks. Here is my complete sub.. htis should work, right??? Private Sub CategoryID_NotInList(NewData As String, Response As Integer) Dim db As Database, rst As Recordset Dim strMsg As String, nd As Variant nd = NewData strMsg = "'" & nd & "'...

I've done this as per Access help descriptions and examples but it doesn't seem to work... What I'm trying to do is select from multiple collumns in a table (or query; same non result) but all I get in the forms combobox is the value from the first field specified. Here's the SQL statement...

I've asked this question in another forum but then realized that perhaps it was the wrong forum for the question. Or perhaps I'm just too impatient and find it hard to understand that other folks might just like to enjoy their weekend. LoL! (Btw, hope everyones weekend is/was great!) Here's...

This is likely a problem of my own making but how do I fix it? The problem is when I press <F11> to display the database window it opens but places itself just outside the Access window... all I can see is the bottom portion of the database window and I can't move it back to gain access to the...

Maybe I'm overcomplicating things for myself but I need to do some simple math and it's not turning out to be too simple! I have a form that a technician can enter the start time and the end time spent on a particular job so we know how much time to invoice the customer. TimeOut - TimeIn should...

<groan> I have two forms that use the same table. The table is an employee record, (name, address, phone, etc) and Form1 is used to gather this info. Also on Form1 I've created a text box control that opens Form2 on focus, if the field is null, which is used to gather information for a...

This is a two-parter akshooly. :-p In MS Access2K I've added a text box to a form to display to the user the retail price of an item. It's a subform contained within a form and I've simply typed an expression in the text box I created by dragging from the table to the form whilst creating the...

What would be the best approach to adding a number field to a table that would increment automatically from a predetermined point (not necessarly &quot;1&quot;)? I intend to display it on a form unedittable by the user to use for purchase orders, etc. The number should always be unique as...