Recent content by amourdevin

Thank you!

I am a newbie teaching myself from a book. Thanks in advance for any assistance and patience offered. I have a cell value that contains text (string). The value could otherwise be a valid formula expression [e.g., =SUM(A1:A2)] but for the moment it is only a value in a cell. Can this value...

I am admittedly near clueless. The field I want to update is a long integer called [ToolRoomEmpID] I will attempt to work out the syntax correctly on my own but would appreciate help (spoon feeding I suppose) if offered. If I correctly figure it out on my own, I will post that upon success.

I would like the user to always be forced to enter something a particular field even if it means redundantly reentering the preexisting data.

Is there a way to force the user to enter a new value in a form even if there is preexisting data? It would be OK for the user to enter the same information (confirm the preexisting data) but I want to force the user to enter something. Thanks in advance!

If not adding new records on top of the subform, perhaps a popup type window instead for adding the new record?

The same question I am hoping to find an answer for.

Thanks! By default, it searches the current field. Is there an argument, option, etc. that will have it search all fields by default? Option Compare Database Private Sub Combo30_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs =...

I am not an Access expert! With that said, I would like to create a form that would find a specific integer value in any of five long integer fields on a single table. Once found, I would like to be able to find the next record that has that specific value in any of those five fields. Thanks...

The expression: SaturdayOfWeek: [When]-(Weekday([When],[vbSaturday])-1) did not work as literally written. What did work is: SaturdayOfWeek: [When]-(Weekday([When],7)-1)

I tried the suggestion: Create a field called "SundayOfWeek" in the query and group by that...something like this: SundayOfWeek: [DateField]-(Weekday([DateField])-1) It seems to be work great for a week that starts on Sunday. Instead I tried: SaturdayOfWeek...

Thank you!! Works great!

For clarity's sake: EmployeeID was: 00017, 00123, 71060, etc. The new field produces: *17*, *123*, *71060*, etc.

Great! That worked!! I have another problem now. I previously used the format 00000 to force employee number to be five digits (leading zeros if necessay). I lost that feature now.

I have a report: [EmployeeID] [LastName] [FirstName] I want to repeat the EmployeeID field but have an asterisk added to either side of the value so it ultimately can be used with a 3of9 barcode reader: [EmployeeID] [LastName] [FirstName] *[EmployeeID]* I do not need help repeating...