Dear Experts,
Currently i'm developing an access database that connect to sql server. i just want to have the code to alert the user to connect to the lan if they are not connected to the ...
Hi
I'm updating a field in a table in a loop with differnt values which is based on another table i'm looping.
Everytime I update the values I export it with DoCmd.transferSpreadsheet and ...
I am writing a VBA module and I would like to create a table that contains some records from an existing table. I do NOT want to specifiy the field names because I want to use the module to c...
I have a listbox that I want to have multiple select criteria. I need the code added to my existing code. Does anyone have ideas on how to accomplish? Below is the code.
Hi I need to export a query to excel template and this template has to be refreshed by any query that I want to do everytime.
There are 2 tab, one with raw data and the second with pivot tabl...
Hi,
I am designing a database in access 2007 that creates timesheets based on time entered into the database. I have created a form that will allow for a report to be generated for each tec...
I have attached a screen shot of my database schema.
This is my scenario;
There are 3 different situations when it comes to searching a quote.
1. You have a job with 0 quotes.
2. You...
I have a subform that the user wants to be able to enter the data once in RecordID = 1 and have the option to update the remaining records for a particular mainform.RecordID ( may have multipl...
I have recently had to reinstall Windows 2003 Server due to a problem with the current box. I have everything up and running except for a few Crystal Reports. The reports are linked to a Acces...
I am trying to do the following:
Update Table TMain to set PendingTX in Table TMain to True when PendingTx is False, Ordered is Null Hold=False and Date()-DateEnter >89. DateEnter, Hold, ...
I have a count query that works fine. The user runs and it produces a count in the query grid.
However, displaying the count in a query grid does not give my application a polished look. I ...
I'll be using MS-Access to create a new record in a database, before the record is created it will need to generate a standard e-mail (template) with the To and CC fields BLANK. When the user...
hi, i am using m2sys biometrics m2s1scanner,the problem now is if the fingerprint scanner is not connected, we can manually press a hot key & can manually give username &password , now i want ...
Easy question
I want to know how to refer to a table field.
I have tried on my own for a good hour now and unfortunately cant figure it out myself!
what I want is to find the value in...
hi
i have a simple sql select query that checks if certain text exists in a table
how can i incorporate vba code [or do it in sql if possible] that will add the text to a new record if i...
I have a sales application created in an earlier version of Access, that links SQL Server 2000 tables (i.e. It is the front end for a SQL Server 2000 back end). I recently upgraded to Access...
Hi,
I am trying to write some code for a form with pull down combobox and a subform in Access 2003. The subform is a datasheet. The pull down combobox contains a list of groups and the dat...
Here is the original question that I posted previously:
I want to update tblTemplate with data from tblSource (see attachment).
The task is to append all the records from the selected fiel...
Hi, I'm importing text data from a supplier. The first 4 records contain text information that I don't need, but the supplier is unable to remove them. This puts text data into the first fou...
I have 4 fields to evaluate: Vendor ID, Invoice Number, Invoice Date and Invoice Amount.
I am trying to write a query that will return all rows where 3 of those 4 fields are identical, but 1...
Hi experts,
I'm trying to insert records from tbl_A to tbl_B. Each record in tbl_B contains a unique caseID. I want to prompt an error message if any of the records in tbl_A that I want to ...
I would like to see the items on top sorted by when they were last made 'active'. Also notice how the items in the top half of the form scroll down below the middle brown area. I would prefe...
I'm a little perplexed. I've have similar functions that as far as I can tell work just fine. Can anyone see what I'm doing wrong in the following syntax?
The error that is raised is:
Run-...
Okay, here's the scenario:
Each record has a Primary account number. Some records can have additional account numbers which the user will add to a listbox.
What's the best way to store ...
I have just installed Access 2003, and when I try to use an MSChart control, VB Intellisense only gives me the properties for a CustomControl Object i.e. the drop-down box doesn't list the pro...
