Search results for query: *

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...

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 =...

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...

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.

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...

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...

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...

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

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...

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...

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.

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...

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...

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...

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...

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?

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...

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

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...

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