Posts by bugs63

    I am Creating a Form to Track The Number Of Spaces in a Parking Lot. The End User would input whats ever was counted in the way of space then input that information in a TextBox. I have written the following code to handle the math portion of the program, the only problem is that I would have to write this code 265 times. the question is can this be done as a range of textboxes.

    I wrote a excel program to track a parking lots vehicle inventory every hour the program requires that the current date be inputted. The counts starts at midnight and ends at midnight the next day. The program then is Saved By Date "C:\SBD" folder. The problem is that when the folder that contains the data the SBD folder is selected for viewing or printing for whatever reason the date has to be enter again. The macro that contains the code is in this folder "C:\ Spaces". Apparently when the file is saved to the SBD folder the macro that has the codes for inputting the date is also being saved. My question is. Can the program be saved without the codes carrying over to the SBD folder?. Any help would be appreciate it Thank You.:)

    I can not figure out why this code is not working i is there something wrong with the way the code is written? I am trying to save by dates instead of names SBD = Save By Date. the code looks right compiles ok but when I run it won't work the problem is where I underline it, K6 is the cell where the data is stored.

    Sub Button2_Click()
    Dim Path As String
    Dim SBD As String
    Path = "F:\SBD\"
    SBD = "SBD"
    SBD = Range("K6").Text
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:=Path & SBD & Format(Now(), “DDDD / MMM / D / YYYY”) & “.xlsm
    Application.DisplayAlerts = True
    End Sub
    1. Sub Button2_Click()
    2. Dim Path As String
    3. Dim Filename1 As String
    4. Path = "i:\Saved By Dates\"
    5. Filename1 = Range("k6").Text
    6. Application.DisplayAlerts = False
    7. ActiveWorkbook.SaveAs Filename:=Path & Filename1 & ".xlsx", FileFormat:=xlOpenXMLWorkbook
    8. Application.DisplayAlerts = True
    9. End Sub

    Hello, I am looking for some help with access I need to create an access form or program that keeps track of the number of vehicles that park in a parking facility which has 7 location but within one facility all with different vehicle capacities. I don't know where to post the question.

    :?:Is There a Way To Create A Command Button, for example a Cancel Button that can take the programmer "in this case me" right to the code page even if the program is running. i am trying to create an administrator type password so that me or any one with a password can access the code.

    Why Is It Cutting Off The Top Of The UserForm it should show the minimize and Maximize as well as resize i am not sure what they are call but they are next to

    the X to close the screen. Any Help would be appreciate it.