| Thread | Last Post | Replies |
|
| Storing and managing images - Advise | 12 Apr 2005 19:29 GMT | 1 |
I need to manage images in a small SQL Server / Access 2003 / Adp project. At the moment I would like to give the opportunity to users to have a thumbnail of the image, open a container for the image and give user the opportunity to print it.
|
| Insert special character in a field with the press of a button | 12 Apr 2005 18:26 GMT | 4 |
Good day, Is there a way to create a button on a form that can paste a predefined character in a field where the cursor is? In other words... I need the user to be able to place the cursor in a field
|
| dbl click unbound text box to bring up that report | 12 Apr 2005 17:08 GMT | 4 |
i have an unbound text box that generates a number showing how many people are signed in. here's what i would like to do... 1. single click - bring up the report showing who's reserved a seat for
|
| Object Change to Open Report w Correct Value | 12 Apr 2005 16:47 GMT | 8 |
I have been stumbling for too long over this one. I have a form with a Text box and the value placed in that Text box (LotNumberTextBox) needs to be transferred to the Report, which uses a query based on the value in the text box. This means that I need the value to stay there ...
|
| Is accessing the current time and waiting for it to change possible? | 12 Apr 2005 16:30 GMT | 7 |
When our product comes through our packaging department, the boxes information gets entered into our database and labels printed out. The boxes all have a reference number that depends on the date and time of day. Therefore if two new records are created within the same minute ( I ...
|
| problem with DCount | 12 Apr 2005 16:18 GMT | 3 |
I have a database consisting of a number of table. I also have an input form which consists of main and sub forms. One of the sub forms relates to one table. If I run the sub form by itself the dcount statement below works:
|
| How Do You Debug These Problems? | 12 Apr 2005 16:13 GMT | 4 |
I have a DblClick event procedure that has an OpenForm method call: DoCmd.OpenForm "fmTickets", acNormal, , "RemTkt = " & ticketID, acFormEdit, acWindowNormal If all goes well the Cancel argument of the Event Procedure is set to False.
|
| Using Global Variables | 12 Apr 2005 16:09 GMT | 4 |
Hello to all, Is there a way to use a global variable in my reports and forms? I have 3 forms and 3 reports that need to have an agents name appear in the header section when opened.
|
| correct way to handle excel files stored in mdb | 12 Apr 2005 16:04 GMT | 3 |
I have an mdb which contains a field where we put an excel files (each 40k) This file is huge (100 meg) If this file is link to an access database does it put load on the network even
|
| setting rowsource on combo box | 12 Apr 2005 15:50 GMT | 1 |
I have a form with three combo boxes. Each of them requires "ALL" to appear in the list and so I have as the recordsource a SQL statemenmt including a Union as follows: SELECT "ALL" As user_stat_desc, 00 AS user_stat_code FROM t_status
|
| One file or multiple files | 12 Apr 2005 15:47 GMT | 2 |
In one application i want to use one of three external look-up tables in mdb format. (I use openforseek() to makeindexed search in external mdb) Knowing that i will always use one of the three tables depending on the
|
| calculating the # of weeks in a period with variable start and e. | 12 Apr 2005 14:31 GMT | 7 |
Have a form with fields "Date" "Survey Period" and "Week." There are four survey periods during a 52 week year that begins on 11/3/2004. Each survey period has 13 weeks, so the first week of the second survey period would be 2/2/05, and so on. I want the field labeled "week" to ...
|
| Count Yes/No Field = True | 12 Apr 2005 14:28 GMT | 8 |
Expr1: DCount("[eBay]","tblParts","[eBay] = " & [tblParts]![eBay]) This is the expression I am using, where eBay is a yes/no field. This is counting all the records in my database. Can someone explain how to count only when values of eBay are True?
|
| Adding All to a combo box | 12 Apr 2005 13:37 GMT | 5 |
I need to add ALL to two of three combo boxes on my main form. Each combo box has an underlying query which selects the unique values from an Orders Summary Query. How do I add "ALL" as first item in all three combo boxes? The first combo box, cboDivision lists all unique ...
|
| Need help w/ Custom Primary key with letters and numbers? | 12 Apr 2005 13:07 GMT | 2 |
My name is Dat, QC Inspector I need help on create a Custom Primary Key with letters and numbers? (example Lot Number: 75AE1101, 75BD0401, etc..) to use in a multiuser environment.
|