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

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

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

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

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

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

I have a form with a field called cbostartdate. When you advance to the next record 1 day is added to the current date by this code: Dim NextDate As Date NextDate = cboStartDate DoCmd.GoToRecord , , acNext If NewRecord Then cboStartDate.Value = NextDate + 1 Is there a way to prevent...

I am building a database and have run into a problem. I have form with a combo box named cboDate that uses a pop up calender to choose a start date. There are four other fields in the form - projectcodeAM, functionAM, projectcodePM and functionPM. This DB tracks half days of employees time...

I am an accountant and not a programmer, but am trying to finish this database for my internal audit group as we have no support for this. I currently have a form that is used to enter data into a few fields. I have about 25 users that will enter data and a table set up for each user to...