Search:

Type: Posts; User: Lastcall; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Sorry, I think I got what you all were...

    Sorry, I think I got what you all were suggesting; I did the debug print and it is displaying what I would like to insert into the output table; I remove the single quote before executing the runSQL...
  2. Ok, this is what I got...Everything looks good,...

    Ok, this is what I got...Everything looks good, in the local window, until trying to execute the RunSQL, there is a "enter parameter value" prompt for the variables already established (TableList,...
  3. Hey, Ruirib! thanks for the response. My problem...

    Hey, Ruirib! thanks for the response. My problem is I know after the INSERT INTO you have to state the name of the table, then respective fields where i want the VALUES data to be inserted. I looking...
  4. Execute an INSERT INTO where table is named on a Set statement field

    Hi, All! it has been some time since I've been playing with Access database, I was trying to brush up a little :). I have the below event procedure that is giving me debug errors and can't see why it...
  5. Replies
    3
    Views
    781

    Tracking deleted table records

    Hi, all! Happy new years!! :D I'm trying to figure out a VBA code to append the selected record that will be deleted from a form (on datasheet view) when the user press the yes option from the...
  6. Replies
    3
    Views
    677

    Guys, you are the best!! Thanks for the help;...

    Guys, you are the best!! Thanks for the help; that really solve my problems. By the way, I noticed I didnt place the month function on [startDate] which was preventing the code to execute properly if...
  7. Replies
    3
    Views
    677

    Hi, all! I am having issues trying to use the...

    Hi, all! I am having issues trying to use the date,now, etc. function to show the first of the month. I have an append query that have a date field column with dates that could be older than the...
  8. Wow! Andrew your are awesome, that works...

    Wow! Andrew your are awesome, that works perfectly..Thanks for your support..:)
  9. Wow! guys I really appreciate all the help in...

    Wow! guys I really appreciate all the help in your post. I have tried manually and all; the file still comes missing the # sign as some of you noted. All this trouble for me is because this export...
  10. Hi, all! I'm having a little issue when executing...

    Hi, all! I'm having a little issue when executing an .csv export which remove the "#" on a field name ( file #) and replaces it with a "." (file .) How can I prevent this from happening? Currently...
  11. Replies
    2
    Views
    883

    Andrew, that worked perfectly!!! you are the...

    Andrew, that worked perfectly!!! you are the best...what are you refering to a spec file? Just for my future reference
  12. Replies
    2
    Views
    883

    Hi! All; I'm doing this process manual at the...

    Hi! All;

    I'm doing this process manual at the moment, but would like to execute this with a VBA code. I need be able to export an access table as a .csv file extension. but the filename has to be...
  13. Replies
    6
    Views
    765

    John-Currently, I have a form in datasheet view...

    John-Currently, I have a form in datasheet view with 4 checkboxes per record. Below is the code that I'm using to allow the users to only be able to select the checkbox accordantly:

    Private Sub...
  14. Replies
    6
    Views
    765

    Thanks guys! AKW the OnCurrent event with some...

    Thanks guys! AKW the OnCurrent event with some extra if statements for every checkbox in the form, made it work just like I wanted it. see below:

    Private Sub Completion10_Click()

    If...
  15. Replies
    6
    Views
    765

    Hi, Everyone! Have a little issue on a form (in...

    Hi, Everyone! Have a little issue on a form (in datasheet view) that has 4 different bonus checkboxes fields (holiday, 10 perc, 5 perc, no bonus) but when I use the ".enabled" property to make one or...
  16. Replies
    22
    Views
    1,111

    Hey, guys! I really appreciate all ya...

    Hey, guys! I really appreciate all ya do...thanks..:-)

    Dont know if ya were able to open the database sample that I posted with the images. but it does make sense to create an update query to...
  17. Replies
    22
    Views
    1,111

    No worries, HansV!! I know i am not getting my...

    No worries, HansV!! I know i am not getting my point across; I was able to emulate the thread you suggested. It creates the sequence as new files are created, not when the files are already existing...
  18. Replies
    22
    Views
    1,111

    HansV, I have being trying to get this done but...

    HansV, I have being trying to get this done but cant see to find the solution. I came up with the below event procedures to change all records in the field in a sequencial order.The field default...
  19. Replies
    4
    Views
    410

    HansV, you're the greatest!!! thanks a million,...

    HansV, you're the greatest!!! thanks a million, once again..:0)
  20. Replies
    4
    Views
    410

    Hey HansV, thanks for the code; by the way, I...

    Hey HansV, thanks for the code; by the way, I notice when I pasted the code in the module and this line "d = (EndDate - BegDate) 7" fonts is red; any idea?......
  21. Replies
    4
    Views
    410

    Trying to create a query that can count the...

    Trying to create a query that can count the number of Fridays on a designated date range. Any help..
  22. Replies
    22
    Views
    1,111

    I read the whole thread, if I use the before...

    I read the whole thread, if I use the before update or On load event the code changes the field value Accordantly. I am trying to make the code loop thru the selected records in the subform and...
  23. Replies
    22
    Views
    1,111

    HansV, thanks for the thread, I got the code...

    HansV, thanks for the thread, I got the code below to add the number to the first record but is not looping to the next record in the subform. Any ideas?

    Private Sub Form_Load()

    Me.VCHR_LN_NO =...
  24. Replies
    22
    Views
    1,111

    Here is a sample of database and two images of...

    Here is a sample of database and two images of what I am trying to do automated.Thanks for all your help.
  25. Replies
    22
    Views
    1,111

    It's like 25 or 6 to 4...

    It's like 25 or 6 to 4... http://windowssecrets.com/forums/images/smilies/smile.gif

    :-) No worries. The header table has: a one to many relationship to the detail table. Fields: (key-no...
Results 1 to 25 of 192
Page 1 of 8 1 2 3 4