A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Using Forms Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Dsum() return a negative by TeeSee
Could someone please explain why the following Dsum() returns a negative number. Thanks Dim intRecCount As Integer intRecCount = DSum("ynDelete",...
March 10th, 2008 02:07 PM
by BruceM[_2_] Go to last post
2 107
Running total on a form using DSum by idtjes3
Hello I'm trying to create a running sum of 4 different types of mixes and i'm getting nowhere. The form im working on is actually a subfrom ( called...
March 10th, 2008 01:52 PM
by idtjes3 Go to last post
4 162
Generate next number that starts with a letter by AnnieJ[_2_]
I have a field with despatch note numbers, each number starts with a D, e.g. D1234,D1235,etc. I want to generate the next available number, ie Dxxxx + 1. I...
March 10th, 2008 12:38 PM
by Douglas J. Steele Go to last post
1 93
Next Number and Unused Registration Number by Frank Situmorang[_2_]
"Anggota Jemaat" and for SS member( Sabbath School Member/not baptized yet) we do not assingn the number ( live it blank/zero). Thi is the VBA to add the...
(Multi-page thread 1 2)
March 10th, 2008 12:26 PM
by Steve Sanford Go to last post
14 166
Pivot Table VBA Reference Book & Blank Cells by David Saywell
Hi Everyone, I have a Pivot Table in Access 2003 and need the blank/null cells on the data axis to display "0". This is easy to do in Excel but I have...
March 10th, 2008 11:45 AM
by David Saywell Go to last post
0 113
Display apostrophe in Combo Box by cmw
I have a combo box which displays the employee names from a table. Users select an entry to "reassign" a unit of work to another individual. There are...
March 10th, 2008 10:12 AM
by cmw Go to last post
4 104
Form control events get broken. by DavidBoyle via AccessMonster.com
My colleagues and I have a problem that occurs while designing access forms and it isn't helped by the fact that our applications have a lot of buttons on...
March 10th, 2008 10:11 AM
by DavidBoyle via AccessMonster.com Go to last post
2 85
Executing record operations from a Master Form to a Subform by Mark Asbell
Hi All I have a single master form that is set up kind of like a web page in that it has frame areas. Heading, Company Logo, Main Work area - which is a...
March 10th, 2008 06:14 AM
by Mark Asbell Go to last post
2 96
Control Alignment in Access 2007 by JessiRight77
I am having a terrible time moving and re-sizing controls in "Design View" using the new Access 2007 version. In older versions of Access, I could move...
March 10th, 2008 05:01 AM
by JessiRight77 Go to last post
2 59
Problem with If statement by Hilary Ostrov[_2_]
I have been using code to alert user to changes that need to be made to a record under certain conditions in Form Current. CL_Type can be either Adult or...
March 10th, 2008 03:49 AM
by Hilary Ostrov[_2_] Go to last post
5 68
How to reference a field on a subform by Dave
Access 2003 Example: If IsNull(Forms!frmEditDispatch.articles) Then the field "articles" is not actually on the form "frmEditDispatch" but a subform...
March 10th, 2008 03:06 AM
by Dave Go to last post
2 78
Search help needed by Dave
Access 2003 search form frmSearchDonors will have 1 field "txtSearchPhones" it will also have one button that is meant to open a form with the donor record...
March 10th, 2008 02:22 AM
by Dave Go to last post
9 136
Help with SQL by TeeSee
Could someone please critique the following pice of code? The SQL was copied directly from the query Private Sub cmdDeSelect_Click() Dim strSQL As String ...
March 9th, 2008 10:31 PM
by Albert D. Kallal Go to last post
3 89
Lost scrolling in A97 code window by Les Desser
I changed my mouse and upgraded from IntelliMouse v4 to v5 or v6. Scrolling in general works fine in forms and forms design but not in the code window. I...
March 9th, 2008 10:18 PM
by Les Desser Go to last post
2 80
Deleting Records by TeeSee
Access 2003 I have a small table with (among other fields) two check boxes one, if checked, allows that record to be shown on a form. Once that record has been...
March 9th, 2008 06:40 PM
by TeeSee Go to last post
4 73
Limit the data selection based on two fields? by Cam
Hello, I have a data entry form where user input the data. Within the data fields, I have field call Item, Side, sequence field where any combination of...
March 9th, 2008 05:39 AM
by John W. Vinson Go to last post
3 100
Copying data form to form by unknown
I have a small access database that I have created. I have one table with three forms. There is a few duplicate data fields on the forms but not all. I have...
March 9th, 2008 05:04 AM
by Steve Sanford Go to last post
1 74
retrieving incomplete records on a form by Jon M.
I have a form based on two tables which are linked by a record#. One table is simple employee info first name, last name, id#, etc... the second table is a...
March 9th, 2008 04:43 AM
by Steve Sanford Go to last post
1 67
Text in Title bar of msgbox by Dave
When I create a msgbox can I have my own title instead of it saying Microsoft Access? Also - anyway of sizing it? Thanks In Advance Dave
(Multi-page thread 1 2)
March 9th, 2008 12:50 AM
by Dave Go to last post
10 199
When the report's parameter query returns an error because of null by [email protected]
I have a report that generates mailing labels for birthday mailing cards. Its record source is a parameter query that asks for the birthday month numeral. The...
March 9th, 2008 12:23 AM
by John W. Vinson Go to last post
1 118
Post New Thread


Display Options
Showing threads 10861 to 10880 of 43162
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.