Return "No Matching Records"
I have a form based on a query. When it opens, if the underlying query has no
records, I have a macro that conditionally uses DCount("*","frmCalendar1")=0
to successful | | 2 | 59 | 11/11/2009 6:40:01 AM |
Images in MSFlexGrid
I'm looking for a simple way to resize images to fit in cells in MSFlexGrid.
Currently I have no trouble loading the images, but they are cropped because
they exceed the size of the cells | | 2 | 54 | 11/11/2009 6:26:02 AM |
Creating "key" fields when met, unlock the next step...
I am researching how to create veritable "gates" in a database so that when
someone initilializes the process filling out a form, they cannot progress
beyond a certain point in t | | 1 | 46 | 11/11/2009 5:09:38 AM |
multiple subforms linking
I've had a wee look around all the posts on here but I seem to be going round
in circles so I'm sorry if the answer is already out there! I'm also a bit of
a (pretty much self-taught) acce | | 2 | 64 | 11/11/2009 5:04:41 AM |
Access 2000
I must be daft. On Google and Access help I've found everything there is to
know about the AllowShortcutMenus property except how to use it. What is it
a property of? Application? CurrentP | | 2 | 50 | 11/11/2009 4:19:09 AM |
Help Linking Subform and Form
Below is a sample of my coding in my program. What happens is when I make a
selection in a field in my subform..it opens a form that reveals only the
information needed for that particular | | 1 | 52 | 11/11/2009 4:08:58 AM |
suppress 12:00 time
I use a single column for both date and time of events. I have two fields
(one for date, one for time) and the formats of the fields are set to just
show a date or a time, not both.
| | 2 | 46 | 11/11/2009 3:43:27 AM |
Syntax error
Hi,
Could someone help me to correct the following line. Thank you.
intYounger3Y = DCount("[Name]", "tbRegVacc", "[Birthdate]< DateAdd("y" - | | 2 | 48 | 11/11/2009 3:30:46 AM |
Dcount type of function on a form
What can I use on a continuous form to tell me when there are no records on
the form? I can't dcount the underlying query of the form, because the user
might further filter records on the | | 2 | 62 | 11/11/2009 3:27:48 AM |
Form Code to update the table
I am beginner to ms access.
I have created form and then insert a tab control (3 tabs) in a form.
I am trying to write a vba code to add/update data into the table.
I have created a tab | | 10 | 36 | 11/11/2009 3:25:20 AM |
Add Record from Event Procedure
I am trying to modify an existing database. There is a form with a subform.
I have added a combo box at the bottom of the main form called
txt_add_employee. I want the user to be able to m | | 1 | 61 | 11/10/2009 11:59:05 PM |
Insert Into 2 tables from a form & subform
Any help would be appreciated:
I'm trying to add lines to two different tables in two steps. One line to the
first table and multiple lines to the second. The number of lines equals th | | 1 | 48 | 11/10/2009 7:17:51 PM |
form filter
I have taken over a database and the code it a but confusing to me. I have a
form in which the user selects a report from a list on the right and then
inputs a from and to date in the corresp | | 3 | 39 | 11/10/2009 6:51:08 PM |
Three state bool
I thought I've seen some sort of tree state bool field type,
electronics speaking hi, low, hiZ..
Just my imagination? If it exists, can it be bound to a checkbox (yes,
no, grey?). | | 2 | 50 | 11/10/2009 3:49:59 PM |
Continuous form set focus
Hi Group,
Win xp Access 2007
This is my first effort at working with continuous subforms.
I've read through the posts I can find about continuous forms but nothing
see | | 8 | 60 | 11/10/2009 1:57:34 PM |
Automatically update a text field when any entry changed
Hi,
I have 2 fields, 'Record Type' and 'Record Status' that I would like to
automatically update to 'Pending' (in the Record Type field) and 'A' (in the
Record Status field), wh | | 3 | 43 | 11/10/2009 11:04:02 AM |
Form and Subforms link Problems..
Good day to everyone!
Ok, before I start, please take a look at my table...
tbl_Operating_Units
Unit_ID
Operating_Unit
Acronym ==== (ex. BAS, ATI | | 0 | 63 | 11/10/2009 5:04:31 AM |
Populating Combo Box With DB Objects
Access 2007 sp2.
I want to populate a combo box with Database objects and have that object
open when
selected in the combo box. I'm not sure where to begin.
For instance, I | | 3 | 56 | 11/10/2009 12:48:38 AM |
Combo Question
I have a 3 colum combobox and have the first column set to 0 to hide it, and
it is bound to column 1. Works just as I want it to.
However, when he dropdown list is visible, I have it | | 4 | 29 | 11/9/2009 11:16:01 PM |
acSaveRecord issue and required fields
i have a button for exporting a single record into a report and e-mail... the
problem is that when the record needs to be saved first, but i don't want
this to be allowed without all the req | | 0 | 41 | 11/9/2009 10:50:37 PM |
set reference with VBA
Hi,
Could someone tell me how i could set references with VBA code in the
starting procedure of an application so that it will run on computers where
the users have not set the | | 1 | 46 | 11/9/2009 9:03:50 PM |
Transfer Spreadsheet Issue
Hi All,
I am having trouble with the transfer spreadsheet function. It was working
fine when i had it pointing to my C:/ drive but when i tried to switch it to
my shared M driv | | 1 | 53 | 11/9/2009 8:19:01 PM |
Calendar 12 AfterUpdate Function Missing
Hi,
I'm trying to use the Calendar function to requery a subform but there
doesn't appear to be an AfterUpdate function to carryout and tasks when the
date changes. The only eve | | 1 | 46 | 11/9/2009 6:05:29 PM |
My Folder
I am trying to create a Cmd Button that when the user clicks on it a file is
saved to their My Documents folder. how would I accomplish this using Access
07. thanks
Bleow is what I | | 4 | 48 | 11/9/2009 6:00:43 PM |
How do I select hidden fields
I'm in Access 2007. I have a form I'm designing and I've got several fields
hidden behind other fields. How do I select them so I can do something to
them without having to minimize the ot | | 1 | 45 | 11/9/2009 5:50:42 PM |
Force Update of Subform Data
I have a form with the following contents:
* "Start" and "Stop" time fields
* frmNavButtons subform with custom navigation buttons that include record
validation
| | 0 | 55 | 11/9/2009 5:19:02 PM |
Recalculate fields in subform from Main form
I have a main form which shows job records (income and expenditure items) and
calculates Net Profit.
This form contains a sub form with a number of workers payment records
linked to the | | 2 | 47 | 11/9/2009 4:50:04 PM |
loop thru records to create a union query
Thanks in advance for any help on this.
I have a form with a combo box which has a list of customers. When a
customer is picked from the list, a subform lists price books which
ap | | 1 | 52 | 11/9/2009 4:28:12 PM |
Hiding a Form when a Report Runs
Hi
I thought I had posted this before, but it didnt appear, anyway :-
I have a Popup Form "FRM_HEAD" which has a command button "BTN_PRINT" which
runs a | | 5 | 53 | 11/9/2009 3:06:05 PM |
Disable button
Access2K. i have a form, when user finished enter data and click SAVE button.
I want after that the button is disable. How can I do that?
Thank you in advance.
MN
| | 3 | 51 | 11/9/2009 3:00:01 PM |
Using button in Access Form to search text field
Hello,
I am trying to create a database for a book collection. I have a form
based on the table containing the book information that I would like
to use for circulation, so the librarian | | 8 | 41 | 11/9/2009 2:50:21 PM |
DLookUp Issue
I am trying to use a DLookUp to display a value from a table to a form.
Field to display: Phone, tblAttendee, with criteria of AttendeeType2,
tblAttendee=48
Form to display it o | | 4 | 49 | 11/9/2009 12:45:21 PM |
afterupdate requery on a tabcontrol
All,
I'm a bit stuck and I would appriciate it if some could help..
On a tabcontrol I have 3 comboboxes, which are depends on another combobox.
I do this with some queries a | | 5 | 41 | 11/9/2009 11:50:32 AM |
Cumulative Sum Query
Hi
I need to run a cumulative total in a query based on expenditure per month
so that I can plot two lines on a chart, monthly expenditure and cumulative
expenditure.
Columns wo | | 3 | 109 | 11/9/2009 7:31:01 AM |
Access 2003 and 2007 installation fight
I had Access 2003 installed and yesterday I added Access 2007 (keeping
2003) so that I could get AccessRuntimeOnly code running matters by
generating MDE under 2007.
Now, everytime I | | 21 | 46 | 11/9/2009 7:14:08 AM |
Tab out of subform
I have a from with several controls and a subform that may have from 0 to 15
detail lines. These detail lines appear like a list of labels and associated
text boxes for the user to fill i | | 1 | 57 | 11/9/2009 5:54:21 AM |
NotInList Firing Problem
Here is the current code:
Private Sub cboDefendantsName_NotInList(NewData As String, Response As
Integer)
Static fDataChanged As Boolean
Const cFormName = "frmNEWDEFEND | | 17 | 43 | 11/9/2009 1:10:10 AM |
Can I hide the line between columns in a list box
I have a 3 column list box. Is it possible to hide the vertical line between
the colums? If so, how and can it be done on a column by column basis or is
it all or nothing.
Thank | | 2 | 44 | 11/8/2009 10:36:01 PM |
Run time question
I have a simple database that I'm giving to a couple people.
I went through the packaging, etc. but somewhere in my reading I remember
getting the idea that all I need to do is supply the f | | 1 | 53 | 11/8/2009 3:29:48 AM |
Populate field based on previous entry
Here is what I want to accomplish. I have an OrdTbl that holds the [PO#],
[OrderDate], and other fields not neccessary for what I want to do.
Okay, now in my inventory form I have a | | 3 | 74 | 11/7/2009 8:38:04 PM |
setting form's recordset property
I am having problems with setting form's recordset property.
My subform's form_load event sub includes the following code:
Private WithEvents rstA As ADODB.Recordset
Dim SQL | | 3 | 51 | 11/7/2009 4:29:59 PM |
Code to Give the Italic Font only to selected tex
Hello
I have a form to enter text data.In a txtbox field I need to change only the
selected font to italic.
Whenever the user needs to change the font,
I would like to have a bot | | 2 | 45 | 11/7/2009 3:01:43 PM |
List Box Deselect Issue
Hi -
I have a listbox that allows the user to pick which product to show in a
report. It is Extended MultiSelect. The user picks multiple items, runs the
report and then closes the | | 12 | 40 | 11/7/2009 7:00:02 AM |
Format for MAC Address
I am creating a databse, how do you format the input for a MAC Address? Could
someone assist?
Thanks....
| | 1 | 56 | 11/7/2009 5:38:09 AM |
Continuous form refresh/requery
I have a continuous form, with the fields locked. In order to edit, the user
clicks on a cmdButton in the left margin of the record they wish to edit.
This opens a form in "single rec | | 3 | 43 | 11/7/2009 4:22:01 AM |
Docmd.SendObject
I have a form that uses Docmd.SendObject to create an e-mail attachment with
a snp file.
It runs fine on XP, Vista, Windows 2000 but when open the database on a
Window 2003 se | | 1 | 87 | 11/7/2009 2:37:31 AM |
deleting combo box entry in table
Greetings,
I have 2 forms (frmContibutors & frmEnterNewContrib) that each allow data to
be entered into a table (tblContributors). This table has a relationship with
another tab | | 1 | 48 | 11/7/2009 12:12:25 AM |
Record not saving correctly
I have a basic form, that is bound to a table.
The user are to enter information about a particular block. Once they enter
a work order number I have the system create a block number. Thi | | 1 | 42 | 11/6/2009 10:23:56 PM |
will using MSSQL2005 express as backend overcome danger of wifi connection to backen?
Hi all.
I know that using Access over wifi should be avoided at all cost
because of the risk of data-corruption.
But if I have a mdb-file as a frontend to a MSSQL 2005 express
| | 2 | 48 | 11/6/2009 10:14:58 PM |
Popup Reports
Hi
I have a problem that I would appreciate some assistance with.
I have a popup form (FRM_HEAD) which runs a report (RPT_WEEK_SUM) in Preview
mode from a command button.
| | 2 | 58 | 11/6/2009 7:54:01 PM |
Tabbing creates new record, which I don't want
Hey there,
I have a form that I enter patient data into. From this form you press a
button and it takes you to a final evaluation form, based on the patient from
the previous screen.
| | 2 | 45 | 11/6/2009 5:39:02 PM |
Multiple fields in the CC argument
Below is the code I am using. It works but I need to add stcc2 to the CC
column. I tried the semicolon but that does not work. I'm not proficient in
code but understand it enough to follo | | 2 | 56 | 11/6/2009 5:31:02 PM |
Appending Codes from a list.
Let's say I have a field "codes" in a table named "companies" and a little
table "Codes_LU" which is just to create a dropdown list. And I have a
form | | 8 | 43 | 11/6/2009 5:16:43 PM |
Form Background Color
I have code that is using a checkbox to hide subforms and then shrink the
form. When the checkbox is unchecked i have it resizing the form back to
original size but the background color is n | | 2 | 52 | 11/6/2009 5:13:02 PM |
Updating data in one table on a form to another table
I have two tables. One for PS which contains an PS ID and the Name of the
PS. The other table is Clerical. Which is the main table. On my form I
have the PS Name as a drop down. I wan | | 1 | 49 | 11/6/2009 4:52:24 PM |
ACC2000: Switch report from design view to preview through VBA
Hi!
I create a report at runtime through VBA. Once the report is finished
I'd like to switch to preview view.
Unfortunately there is no .Reports collection in the currentDB obje | | 5 | 57 | 11/6/2009 3:57:02 PM |
insert values into table from ACCESS FORM
I am new to ACCESS programming. I have to perform 2 tasks:
question1: I want to insert all the field values ( around 30) from an ACCESS
FORM when some one checks on field called FINAL , which | | 8 | 46 | 11/6/2009 1:30:33 PM |
Read only
I have a form that I would like to make read only, when I make the form read
only the lookup box that I have becomes read only too. Is there a way to keep
the lookup box useable and have t | | 3 | 47 | 11/6/2009 6:06:01 AM |
dsum error message
Hello. I am using the following dsum but keep running into an error 2471
about the expression entered as a query parameter produced 'BusinessType'. I
can not figure out what the issue is. | | 5 | 47 | 11/6/2009 1:04:05 AM |
code wont recognizie that 10 is greater than 3
Please help...
I have the following code in the after update event of a combo box. The
first 3 conditions are fine but with the last 3 if one zone is 2 and the
other is 10 then it | | 2 | 43 | 11/5/2009 11:41:01 PM |
combo box - bound column
I have a combo box that is not functioning as I would expect:
- its row source has 2 columns: [Note] and [NoteTitle] (this is the order
in the datasource query)
- I have the bound c | | 2 | 49 | 11/5/2009 10:39:24 PM |
making selection group
I have this form with 8 selection (dono how to translate the duch
word... you know... klicking displays a V)
They are all grouped.
Now I added a new item but I don't know h | | 5 | 47 | 11/5/2009 9:29:00 PM |
Which Form Event
Which event do I need to use to be able to compare an .oldvalue vs .value?
I am currently using AfterUpdate event however, the .oldvalue is always
equal to the .value?
Thanks, | | 1 | 54 | 11/5/2009 8:57:19 PM |
Message after duplicate a record
I am duplicating a record on a form using code learned on this site:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acC | | 1 | 57 | 11/5/2009 5:58:01 PM |
Double Control for Names?
I have a Letters Form based off a Forms Form.
In the forms Form I have separate Last Name and First Name Fields.
In the Letters Form I just have one Name Field, formatted Last Name, | | 6 | 40 | 11/5/2009 5:24:26 PM |
populate form with a recordset
Im trying to populate a form with a recordset using the following piece of code
Call open_recordset(rs, qry, check)
If check = 1 Then
DoCmd.OpenForm " | | 3 | 53 | 11/5/2009 1:55:19 PM |
Ms Access got an error and quit
Hi,
I create an application to access finger print attendance device using
their SDK, the source code:
Dim vMachineNumber
Dim bConnected As Boolean
Dim CZKEM1 As Object
| | 7 | 53 | 11/5/2009 10:32:31 AM |
What is best way to re-use an account number?
Hi,
I'm on Access 2003 and will be going to Access 2007 shortly.
Background:
-----------
I have a Charity Fund raising database. When a person joins, they are
as | | 17 | 36 | 11/5/2009 6:18:34 AM |
Combo Box hell or why do I get and error when I do this?
Hello All
I have a few situations where i am trying to get a combo box to do soemthing
and it keeps giving me errors or not doing what i want.
in the first instance i am us | | 3 | 42 | 11/5/2009 5:53:13 AM |
Switchboard filter
Hello,
I have created a switchboard (not using the built-in tool). Works like a
charm. But recently I have been banging my head against a wall trying to
figure out the following. | | 3 | 59 | 11/5/2009 4:37:19 AM |
Locking a record without using the new record feature.
I have used the lock record that is not new function before. But how do I
lock a record after the initial data is entered, but the initial data might
not be entered when the record is first | | 3 | 41 | 11/5/2009 2:31:20 AM |
macro help needed
I have a macro designed that is used in a right mouse click event on a
textbox (PSID) on form1, which is a continuous form. It is a simple GO TO
and it opens up another form, form2, which | | 2 | 61 | 11/4/2009 10:16:01 PM |
function assistance
Hello. I am having a day in which the mind just isn't working. I need to
put the following code into a function (module) but drawing a blank on how to
do it. Just need to pass the one par | | 5 | 38 | 11/4/2009 10:11:03 PM |
Access Not Responding when VBA Code Run
I'm making a form for generating records to represent a matrix of
experimental results. So if I have three samples for which I need to test
melting point and boiling point we need 6 recor | | 3 | 45 | 11/4/2009 9:35:02 PM |
Looping between a MainForm and a Linked SubForm
My Receipts are processed through two linked forms - with heading data in the
MainFrm and allocations in the SubFrm - which is a Continuous form.
Selected MainFrm data is copied to the Alloca | | 6 | 41 | 11/4/2009 9:11:07 PM |
Cursor Status
I have a field where I want the user to be able to go to a particular
position in the field so they can enter a single character in that position.
Generally this works, but sometimes the us | | 2 | 55 | 11/4/2009 8:37:02 PM |
tolerance place counting
I have an engineering tolerance test result that needs to be kept as a
decimal but the field is dropping the last zero entered. An example is if
the user types in 0.010, the last 0 is ge | | 7 | 62 | 11/4/2009 3:37:02 PM |
OpenReport in a form's load event.
My Access app includes a form with the following bit of code in the load
event.
MsgBox "STUB 0", vbOKOnly
strWHERE = "[qryPreEval]!Evaluation_No = " & | | 7 | 59 | 11/4/2009 2:49:10 PM |
Call a Public Sub-routine on a Sub-sub-form
I am using the custom navigation buttons from www.lebans.com, and he includes
a call to a public sub in a subform, using this syntax:
Call Me.frmNavButtons.Form.EnableDisableButtons
< | | 2 | 72 | 11/4/2009 2:45:57 PM |
94 Hosting Web www.ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Host | | 0 | 88 | 11/4/2009 11:50:17 AM |
Sort by ascending on event
I need a code or some method to auto sort by ascending for a txt box called
txtDate on form load or on a button click.
Thank you.
| | 1 | 55 | 11/4/2009 2:45:58 AM |
Sort by Ascending on button click
I have a txt box named "txtDate". I want to sort by ascending when I click
the button "editlogs".
Your help is appreciated.
| | 0 | 49 | 11/4/2009 12:51:01 AM |
Export to Excel setting field types
I am exporting a query out to excel. The client then fills in the fields and
we import the data back into a temp table that we sort through before
actually populating the assorted tables. | | 14 | 41 | 11/4/2009 12:48:24 AM |
Comboc criteria...Open and display combobox 2
Hi again…
I have this question.
Combobox 1. Fruits
Combobox 2.
If (Me.Fruits = “Bananas”) Then open and highlight the options
available/sub index in Combob | | 3 | 109 | 11/3/2009 9:49:02 PM |
Lock a field after data entry so value cannot be changed
I have a form used for receiving where the receiver selects his/her name when
receiving product. Once they have entered their name I want to 'lock' that
field so it cannot be changed by a | | 2 | 63 | 11/3/2009 7:16:09 PM |
Report Preview is hidden behing the Form
Hi
Hopefully someone can help me with this, there are some solutions here that
almost fit but I cant find the one for me.
I have a Popup Form (FRM_HEAD) which contains a nu | | 2 | 61 | 11/3/2009 4:16:01 PM |
Update Events in Split Database?
I was wondering how I can use BeforeUpdate and AfterUpdate events, or
something similar, in a split database.
I had validation code in the BeforeUpdate event for the record, and it wa | | 6 | 58 | 11/3/2009 4:13:01 PM |
right mouse click event
Hello. In A2003 I was able to develop a shortcut popup menu list using the
right mouse click. I worked by placing the mouse over the field (ex: Sales
Order), click the right mouse button | | 2 | 53 | 11/3/2009 2:48:01 PM |
How to use Seek vs FindFirst
I am trying to update a table with data from a query, but I keep getting
errors like "invalid command" ,etc. What I have is:
My query calculates a sum for each type of record in ano | | 5 | 54 | 11/3/2009 2:32:01 PM |
referring to Subform Total in main form
Hi,
This is probably very simple but has bugged me on more than one occasion. I
have a main form / continuous subform setup, where the subform contains a
control ctlFieldX bound | | 1 | 58 | 11/3/2009 2:24:34 PM |
How to set several events to fire the same procedure?
Hi,
I hope some one could help me in this. How could I have several different
events says mouse click and Enter to fire the same procedure?
Thanks.
| | 2 | 48 | 11/3/2009 2:22:48 PM |
Duplicate sub form last record
Hi all i have a sub form with a numeric field what i am hoping for is when
someone opens the main form and navigates to a new record in a sub form is it
possible to lookup last record and | | 2 | 65 | 11/3/2009 1:26:01 PM |
Combo Box Hell or Why can't I get this code to work?
Hello All
I thought i posted this once already, but it seems to have ended up in
posting limbo so here it is again.
i have this combo box which i need to get to change a te | | 2 | 53 | 11/3/2009 4:04:45 AM |
Refresh/Requery combobox2 on combobox1 change
Hello,
On a form I have combobox1 where I can select a department, on the same page
there are also combobox2 and combobox3, where I can select the name and on
the other their fu | | 1 | 50 | 11/3/2009 12:34:29 AM |
Syntax for Referring to a subform
If I have this layout in a form:
InputStudyData (primary form)
-[Primary Tasks Form] (subform)
--Category (control)
--Interruptions (subform)
How do I refer to the | | 5 | 39 | 11/3/2009 12:31:01 AM |
Filter for years and keywords
Hello
I have a search Form (AllenBromne modified). I would like add two filters,
one to filter between two years, and another to filter Keywords.
I have this code to Filter for | | 6 | 35 | 11/3/2009 12:07:01 AM |
fomr opens to wrong record
I have a command button on a form to open another form to a specific record
to get some information. The form opens to the same incorrect record each
time no matter which record is called. | | 8 | 35 | 11/2/2009 11:55:01 PM |
DoCmd.SendObject Fails
I'm running Access 2007--I believe (the Help|About command has been pulled).
I have some VB code behind a form that was written many years ago and the
following line fails with some vagu | | 4 | 99 | 11/2/2009 7:18:49 PM |
Error in string criteria / Wildcard
Hi all. I have an issue with the DCount and wildcard searc...i recevie String
Error or expected = when i try to run this. All i want to do is to
DoCmd.OpenForm after Then..IF no records are | | 9 | 40 | 11/2/2009 6:51:01 PM |
Data Type Mismatch
Hi all again…I receive Date Type Missmatch on this..
The query is Basket Query, the numeric control is Basket ID and Search is my
text field, different form, were I enter the number to f | | 6 | 168 | 11/2/2009 6:44:01 PM |