|
More site info...
microsoft.public.access.formscoding | Forum profile
|
|
Forum profile page for microsoft.public.access.formscoding on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.access.formscoding, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.access.formscoding" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.access.formscoding:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
112
|
447
|
1,645
|
|
Post:
|
317
|
1,275
|
4,594
|
|
|
microsoft.public.access.formscoding Posting activity graph:
|
Top authors during last week:
user's latest post:
OKay,...
Published (2009-01-07 14:04:00)
Fred's eyes are better than mine: I missed the space. If Len(Trim(Me![Plant ID] & vbNullString)) = 0 Then (or do yourself a HUGE favour, and don't use special characters, which includes blanks, in your names!) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message...
user's latest post:
User Name and Passwords in...
Published (2009-01-07 23:13:00)
On Thu, 08 Jan 2009 06:53:12 GMT, "wajhansmukh" <u48674@uwe> wrote: >Dear All > >can you please help me solving this problem, as i have created a database . >now i need to creat usernames and passwords to enter into data base .. and >they can only access the data entry forms not the other tables of the >database... > >i have attached the...
user's latest post:
Locking an autodate in...
Published (2009-01-07 15:28:00)
One of these days I'll learn to read before typing. Your code does, very clearly, mention .NewRecord... I take back my earlier blurt... Regards Jeff Boyce Microsoft Office/Access MVP "Jeff Boyce" <nonsense@nonsense.com> wrote in message news:%23mHkP4QcJHA.5540@TK2MSFTNGP05.phx.gbl... > The code you offer appears to (re-)set the txtEntryDate EVERY TIME the > cboEnteredBy changes......
user's latest post:
Get filename during Import...
Published (2009-01-07 22:01:00)
Filedialog will allow you to get the name of the file to import. and that can be placed in a textbox. If the files and tables *all* have the same layout then DoCmd.TransferText can be run after the name of the destionation table is picked. If the layout is different then you would have to have a fileimport spec for each file type. If everything *is* teh same the question of why different tables comes up. > >>...
user's latest post:
Moving controls dynamically in...
Published (2009-01-06 19:18:00)
"Stephen @ ZennHAUS" <stephen.huisman@zennhaus.com> wrote in message news:%23NosNUHcJHA.4412@TK2MSFTNGP04.phx.gbl... > Hi guys and gals > > I am wondering if it is possible to move controls on a form by changing > the left and top properties based on options that are chosen in a combo > box. Yes. > Currently I have a number of labels and check boxes on the...
user's latest post:
Locking an autodate in...
Published (2009-01-07 10:59:00)
Is the code below correct if I want a date to autofill, but then never change unless done manually? Also, does it go in the Form Current event, too? Private Sub cboEnteredBy_AfterUpdate() If Me.NewRecord Then Me.txtEntryDate = Now End If End Sub -- GD
user's latest post:
create a popup calendar in...
Published (2009-01-06 11:34:00)
2003 "Tony Williams" wrote: > There is a way to do this in Access 2007. What version are you using? > Tony > > "Gator" wrote: > > > I want to be able to click a button on form1 and cause a popup form with > > calendar control and when a date is selected the popup closes and form1 > > filters the records based on the date...
user's latest post:
query not working in...
Published (2009-01-02 05:13:00)
All of the criteria are included in the query itself. The value being looked up is integer, all criteria are text. I have: intMyVariable = NZ(DLookup("TableID", "qryTableLookup"),0) -- Thanks for your help! Walter "Ken Snell (MVP)" wrote: > Then I'm guessing that you're not delimiting the value from myControl with ' > characters, which is needed for...
user's latest post:
query not working in...
Published (2009-01-02 07:04:00)
Please post the code that you're running; let's see what it contains. Likely we will be able to see the problem then. -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ "Walter" <Walter@discussions.microsoft.com> wrote in message news:F9BB166F-EA21-47ED-96B9-32FB8E95A470@microsoft.com... > All of the criteria are included in the query itself. The value being...
user's latest post:
form detail section background...
Published (2009-01-05 13:53:00)
Have you coded a Debug.Print of the values you're getting? that way you could look at them as you scroll through. Also, there have been times when I had to create a separate variable to hold the results of the calculation, and test that variable rather than "doing the math" in the IF. I have NO IDEA why I had to do that, but it worked. "Gator" wrote: > As I scroll through...
|
|
|
|
Latest active threads on microsoft.public.access.formscoding::
Started 1 day, 12 hours ago (2009-01-07 14:08:00)
by Susanne
I had to go against everything I know about database design since the customer wanted a form to appear exactly as it does on paper. The majority of all fields pull data from the same table (components) and retain the info in a different field, instead of doing a continuous form (one in component 1, a different one in component 2, ... ...
Started 1 day, 2 hours ago (2009-01-07 23:23:00)
by edw12
Hi. I used a variation of this code on a form that I am creating, in order to check for duplicates on entry. However, Access keeps the error in place, even after the duplicate has been removed. For example, Item# 08-12 has already been used. If I enter this Item# again, a popup displays saying "This Item# has already been used. Do you want to use ...
Started 1 day, 13 hours ago (2009-01-07 12:25:00)
by NotGood@All
I get Word documents that have tables (200), the tables consists of 2 fields; 1 is the item number and the other is the details of that item. I would like to append both the item number and the text to a table that has fields named “ItemNumber” and “Description”. Can code be written so no matter how many items are on the agenda they ...
Started 1 day, 2 hours ago (2009-01-07 23:33:00)
by salewholexx@sina.com
discount Air max 95 shoeswww.gotoorder.cn wholesale Air Max 87 shoes discount Air MAX LTD shoes sell Air max 90 shoes discount Air Max 88 shoeswww.gotoorder.cn discount Air MAX 89 shoes discount Air max tn shoes discount Air Max tn8 shoes discount Air MAX tn9 shoeswww.gotoorder.cn discount MEN'S WOMEN'S Shox R5 ...
Started 1 day, 9 hours ago (2009-01-07 17:10:00)
by TeeSee
The following code runs and the variables contain the desired data but the underlying table doesn't get updated. Can anyone see the error of my ways? There are no error messages with this code. It just does nothing! This has been adapted from Graham Mandenos' post of some years ago which was run under the Form_BeforeUpdate as you can ...
Started 1 day, 3 hours ago (2009-01-07 22:55:00)
by wajhansmukh
Dear All can you please help me solving this problem, as i have created a database . now i need to creat usernames and passwords to enter into data base .. and they can only access the data entry forms not the other tables of the database... i have attached the database for your kind review........
Started 3 days, 13 hours ago (2009-01-05 12:27:00)
by Evan
I want to use a query that will get a field value from user input on a control in a form. In the control's after update module I am not sure how to write the code so that the user input is imported into the query. How is this done? Thanks Evan
Started 1 day, 10 hours ago (2009-01-07 15:51:00)
by bhammer
The user clicks a button to launch the GetExternalData wizard, DoCmd.RunCommand (acCmdImport) then browses to a text file and selects a destination table, etc. I want to display the import filename and the destination table that the user selected during the wizard, in text boxes on the form, so that I can have the user verify ...
Started 1 day, 15 hours ago (2009-01-07 10:59:00)
by GD
Is the code below correct if I want a date to autofill, but then never change unless done manually? Also, does it go in the Form Current event, too? Private Sub cboEnteredBy_AfterUpdate() If Me.NewRecord Then Me.txtEntryDate = Now End If End Sub -- GD...
Started 1 day, 6 hours ago (2009-01-07 20:00:00)
by jhalstead85@gmail.com
First time poster so please bare with me. I'm working on an Access 2003 database with a continuous form and I need some help with some conditional formatting. Basically when the form loads I want to compare a field from each record with the same field on the previous record. If the Abs() difference of the two field is greater than or ...
|
|
Hot threads for last week on microsoft.public.access.formscoding::
Started 1 week ago (2009-01-01 06:43:00)
by Walter
I have a query to prevent duplicate entries which is called from a form. The criteria are set to forms!myForm!myControl. When I open the query and supply the criteria, it works but when it is opened from the form there are no records displayed. -- Thanks for your help! Walter...
Started 2 days, 18 hours ago (2009-01-06 08:10:00)
by Jack
Hi, I am using the following code in the form load event to lock a field on a form based on values of fields in the main and the subform. However when I am running this form I am getting the above error: There is an invalid use of the .(dot) or ! operator or invalid parenthesis I cannot figure out why I am receiving such ...
Started 1 week ago (2009-01-01 07:32:00)
by Frank Situmorang
Hello, I do not what is wrong in this formula it says It contains invalid syntax =IIf(DLookUp("[Language]","tblDefaults")="English" , "[ChurchName_E]","[ChurchName_L]") Thanks -- H. Frank Situmorang
Started 4 days, 12 hours ago (2009-01-04 13:19:00)
by Josh
Users input receipts on a form, which has a Date/Time field. The Date/Time field has default value of Now when form loads. But, the default time of the Date/Time stays at that same value, of course, until the Form closes. Because the receipts cover several days or even a week, and then user catches up all at once, I can't update the ...
| |