Forms
in [Access]
|
Problems adding new record from form / subform I have a table (tPNos) containing Project info. The ProjectNo is a text field because we have sub-projects with descriptive suffixes (e.g. 1400, 1400-01, 1400os). The first 4 digits are always numeric and equate to a BasePno. I also have an auto-number PNumId field, that I use to link to other tables. I h... 15 Apr 2010 05:54
rename csv file by removing date/time stamp before importing I have several files that I import every day but I have to manually rename them by removing the date/time stamp from the name i.e. ICM_AMS_MS_Call_Stats_01011901000000.csv has to become ICM_AMS_MS_Call_Stats.csv due to my import script. These are saved to the same filepath every day so I need some function ... 16 Apr 2010 04:01
Multiselect in datasheet view? Hi, I have a table that I am converting into a form. This table (table1) has these fields: QuestionID, Question & Response (Combo Box). I have another table (table2) with these fields: QuestionID, Response. On my datasheet form, the Response combobox values are generated based on the matches it finds in table2... 12 Apr 2010 17:03
Multiselect in datasheet view? Hi, I have a table that I am converting into a form. This table (table1) has these fields: QuestionID, Question & Response (Combo Box). I have another table (table2) with these fields: QuestionID, Response. On my datasheet form, the Response combobox values are generated based on the matches it finds in table2... 13 Apr 2010 18:30
Dates with day below ten aren't found with docmd.applyfilter state Filter fails: the DoCmd.ApplyFilter , "[Date] =Forms![Games Today]![ViewDate]" does not work if the ViewDate field has a date selected where the day value is below 10. Works fine for dates 10 and above. The filter statement appears to be valid and shows as eg. [Date] = #02/12/2009# if script is halted. (I wou... 12 Apr 2010 13:41
Go Through Records by ScrollBar Control Hi all, I am tring to give freez column effect like excel in continuous form. To do that i have created two continuous forms with name "SubA" and "SubB". I made these forms for read only. Then i created another form and gave name "Main" and drag both forms "SubA" and "SubB" on this form with Horzantical scroll ... 11 Apr 2010 10:09
Change position of acDialog form SUCCESS Just to let you know - MoveWindow did the trick! Guess it's the old Keep It Simple principle - MoveWindow doesn't give you any options of changing windowstate. Thanks again for all your help! Turtle "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message news:OYjhNGB2KHA.312(a)TK2MSFTNGP... 12 Apr 2010 04:51
generate a sequence of random numbers For doing golf draws I wish to create a vba function that will generate all the numbers in a given range in random order, e.g. say 5 players with a resultant random order of 4,1,5,3,2 The following only gives me one number at a time Function GenNumbers() Dim RandomInt Randomize RandomInt = Int(((20 - ... 11 Apr 2010 09:02
Counting Weekdays in the Future I want to use Access 2007 VBA add a certain number of weekdays to Now(). I have found very nice sample codes which allow me to determine the number of weekdays between two dates, but I want to do the reverse, i.e., determine the day 16 WEEKdays in the future. How is that done? ... 10 Apr 2010 10:12
IF ElseIf and Else I am having a problem with the code that i have written. I can get the last elseif statement to work but the if and first elseif doesnt want to work correctly. Below is the code that i used, and any help with this would be greatly appreciated. Private Sub Command41_Click() If Me.APPROVED = "yes" And Me.DISAP... 12 Apr 2010 12:34 |