Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Roblin

    Remove text from cell in Excel

    I have a spreadsheet with a single column, but many rows of dollar values. The problem is that the "$" is manually typed in the cell and I would like to use the numeric values in the cell. Is there a macro I could run to remove the "$" ? It seems simple to me, but I can't think of a way to do...
  2. Roblin

    Return last date in a table

    Thanks for the pointer Remou. I got it to work with this: Dim BeginDate As Date BeginDate = DMax("WorkDate", "" & Me.RecordSource & "") If Weekday(BeginDate) = 7 Then Me!cboStartDate = DMax("WorkDate", "" & Me.RecordSource & "") + 2 ElseIf Weekday(BeginDate) = 6 Then Me!cboStartDate =...
  3. Roblin

    Return last date in a table

    Hey Remou, I've been using this: Me!cboStartDate = DMax("WorkDate", "" & Me.RecordSource & "") + 1 and it works good. Is there a way to get it to skip weekends? If the last date is a friday, it adds one to make the new date Saturday. I could add 3 and that works, but if the last date is a...
  4. Roblin

    Return last date in a table

    Wow, that one line of code did what I needed. It works perfectly. I just set the default to 01/03/05 and added that single line of code and it works like a charm. Thanks again.
  5. Roblin

    Return last date in a table

    I have the code looking like this: Dim LDate as Date DoCmd.RunSQL ("SELECT Max([WorkDate]) AS LDate FROM " & Me.RecordSource & "") MsgBox LDate If LDate = Null Then cboStartDate = "01/03/05" Else cboStartDate = LDate End If It's returning a date of Saturday, December 31, 1899. The msgbox...
  6. Roblin

    Return last date in a table

    Hi Remou, Yeah, while writing that I confused myself. One of the fields that is in the tables on the backend for each user is called "WorkDate". It is the primary key. I have a combo box that triggered a pop up calendar that allowed the user to choose a date. The combo box is cboStartDate...
  7. Roblin

    Return last date in a table

    Hello. I have a database that contains a form users input data into. The table that is the record source for this form is dependent on on function that grabs the user's network ID. This table's primary key is "WorkDate". I would like to have the entry form open so that the date after the...
  8. Roblin

    Object Source dependent on user

    Ok Remou, You did it again. Thanks a bunch.
  9. Roblin

    Object Source dependent on user

    Hello again Remou, I don't want to enter data onto the subform. The subform just displays past entries completed by the users so they can see what they have entered as they are entering data on the main form. Doesn't the record source tell the subform where to store data? The second field in...
  10. Roblin

    Object Source dependent on user

    Hi, I have a subform that I would like to set the Object Source based on what user is in the database. I have a backend DB that contains tables that store data for all the users. The frontend points to the correct user's table based on a function that grabs their network ID. I have a subform...
  11. Roblin

    QueryDef to link form to tables

    Thanks for the suggestion snotmare. I got your suggestion to work, but only if I specified the table name for each user. Remou, Again your suggestion worked. It won't creat a new link if one already exists. I really appreciate it. Have a good evening.
  12. Roblin

    QueryDef to link form to tables

    Hi Remou, Another question. In the frontend, everytime I go to the entry form, a new pointer is created. So, I have several pointers in the table section of the frontend. They look like: "tblRDL1", "tblRDL2", "tblRDL3" and so on. I am able to delete them manually. The original tblRDL will...
  13. Roblin

    QueryDef to link form to tables

    Remou, Thank you so much. I just did not know how to do it, but your suggestion totally worked. I haven't tried it on anyone else's machine yet, but the changes worked on mine and I took the record source out of the form's properties. So, I'm guessing it will work on someone else's machine...
  14. Roblin

    QueryDef to link form to tables

    I have a split DB that contains a table for each user in the backend. The frontend contains code in a module that grabs the network ID of the user: Function ap_GetUserName() As Variant Dim strUserName As String Dim lngLength As Long Dim lngResult As Long strUserName = String$(255...
  15. Roblin

    Change Table Link To BE Database

    Thanks Remou. I had tried relinking and even creating new tables, but it didn't work. MoLaker, I was hoping I could do something similar to what you suggested and not have to change the form at all. I have a function in a module that grabs the user's network ID in the frontend: Function...
  16. Roblin

    Change Table Link To BE Database

    Yeah, the record source is tblRXS in the new frontend. I should have mentioned that before. The new front end looks exactly like the other frontend except the table names have been changed. Thanks for you suggestion. Any more ideas?
  17. Roblin

    Change Table Link To BE Database

    I have split a database containing tblRDL. A form named "Entry" is used to input data that is saved to tblRDL. The backend is on a network drive and the frontend is on my PC's local drive. This works fine. I have copied the frontend database for another user to enter data. Due to volume and...
  18. Roblin

    Subform not displaying data

    Well that's twice you saved me today! I really appreciate it.
  19. Roblin

    Subform not displaying data

    I have a form (frmEntry) that inputs data to a table (tblRob). On the same form (frmEntry) there is a subform (tblRob_subform) that should display the data in that table (tblRob), but it doesn't. There is another subform (tblProjects_subform) on the same form (frmEntry) that displays data from...
  20. Roblin

    Add +1 Day, but skip weekend

    Great!! It works. Thanks so much for your help.

Part and Inventory Search

Back
Top