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 Reverse Sort Order Last Post Replies Views
#Error Textbox by Alan
=DSum("","Billings Analysis"," = '" & & "' AND = '" & & "'") Right i used this code in the source code of my textbox and the textbox keeps flashing, i...
March 26th, 2010 02:53 PM
by Daryl S[_2_] Go to last post
3 141
#ERROR in textbox by Alan
I have this code in a text box = dsum("", "", " = " & & " AND Format(, ""yyyymm"") = '" & Format(, "yyyymm") & "'") i keep getting #error in my text...
(Multi-page thread 1 2 3)
March 26th, 2010 03:36 PM
by BruceM via AccessMonster.com Go to last post
28 277
combo box look up text box error by Alan
I used this code =DSum("Amount", "", " = " & cboCustomerNumber & " AND Format(, ""yyyymm"") = '" & Format(cboPostingDate,...
March 24th, 2010 06:17 PM
by Dorian Go to last post
1 119
Combo look up, format from number to text field by Alan
Hi I was given this code to look up on two combo box name Customer Number Posting Date Period which then a third combo box would look up on these two combo...
(Multi-page thread 1 2)
March 25th, 2010 04:44 PM
by John W. Vinson Go to last post
10 186
Looking up 2 combo boxes and then calculate another field by Alan
Hi can anyone help combo box 1 is a customer number 0001 feild(0) combo box 2 is a posting date 2009/07(1) Then i have an amount field with all sales that...
March 23rd, 2010 01:09 PM
by Stefan Hoffmann Go to last post
1 122
sum combo box based on other combo box by Alan
Hi can anyone help i have two combo box which are Customer Number and Period Posting Date coming from the same table, what i'm after is after combo box...
March 23rd, 2010 11:00 AM
by Alan Go to last post
2 133
WebBrowser.Object BackColor ?? by Alan
Hello All HAve put an animated gif into a form using the following code Private Sub Form_Load() Me.ocxWebBrowser.Object.Navigate CurrentProject.Path &...
December 5th, 2009 01:56 PM
by Douglas J. Steele[_3_] Go to last post
1 80
Continuous Forms - Sum of Values by Alan
I have a continuous sub form that uses a query that totals various aspects of the business against departments. I can present each field(cloumn) individually...
July 12th, 2008 08:10 AM
by Alan Go to last post
5 102
date controls by Alan
Hello, I have a date field ona form that I'm trying to prevent the user from entering dates in the past. On the AfterUpdate event I wrote the following code...
October 11th, 2007 05:40 PM
by Alan Go to last post
2 73
hiding button by Alan
Hi folks, I thought what I was trying to do was simple but it doesn't seem to be working. I have a form where there's a date field (saveDate) of when the...
September 26th, 2007 09:01 PM
by Alan Go to last post
2 48
Module to Service Multiple Forms by Alan
This is hopefully a simple question. I have a Sub Routine that I was given a bit of help with previously that updates a number of captions on any form,...
September 24th, 2006 09:20 AM
by Peter R. Fletcher Go to last post
2 58
Problems re; calling report query from within a form by Alan
I am getting a problem while trying to call the following report query called "zel_test" in the application: SELECT transactions.period,...
July 20th, 2004 11:06 AM
by Alan Go to last post
4 381
Conditional formatting in continuous form by Alan
I read an earlier post regarding conditional formatting of rows of a form in continuous mode. The post contained a link to Leban's site which had an example...
October 6th, 2004 01:20 AM
by Stephen Lebans Go to last post
1 135
query result as button label by Alan
Is it possible to have the result of a query as a caption on a buttion. Ie. I have a query which returns a numeric value and would like this number presented...
(Multi-page thread 1 2)
December 8th, 2008 03:24 AM
by IT-1957 Go to last post
11 112
sub total screen by screen by Alan
does anyone know how - using a tabular form - i can display sub totals at the bottom of a screen - eg after 20 records. then have the user press a button to...
September 3rd, 2006 03:08 PM
by Alan Go to last post
2 109
Text Button Colour on Value by Alan
Hello All Looking for a quick bit of advice ... I have a Form which currently contains numerous buttons. I change the colour of the Font on each button using...
September 8th, 2006 06:57 PM
by Alan Go to last post
4 115
Calling Control Info from Table by Alan
Not sure I have the title right here, but here goes Thanks to an earlier post I now have my Form with many buttons beautifully coloured etc. However as I...
September 9th, 2006 08:27 PM
by Barry Gilbert Go to last post
1 75
Fields from multiple Tables on 1 Form by Alan Armitage
I have 5 tables with various filds. Using the Form Wizard I can select fields from up to 3 tables and create and display a single form with the selected fields...
July 15th, 2004 11:13 AM
by Alan Armitage Go to last post
2 523
form selector by alan at work
I want Access to open a form from an open one and the key in both cases is the date. For some reason Access ALWAYS uses the American date format when...
October 7th, 2004 11:19 AM
by alan at work Go to last post
2 126
Data Validation in a Form by Alan B
I have created a data input form and want to validate a dat efield so that it on;y accepts dates which are saturdays. I tried to use : =weekday()=7 But it...
June 19th, 2008 01:22 PM
by Alan B Go to last post
2 105
Post New Thread


Display Options
Showing threads 1221 to 1240 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 03:06 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.