Search results for query: *

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

This is in regard to creating a form. I have two date fields (DateIn & DateOut). I also have a Yes/No field (InStatus). What I would like to do is disable input to the DateIn field when the InStatus field is Yes. I would like to disable input to the DateOut field when the InStatus field is...

You know what I want better than I do! I mean that literally . . . not sarcastic. Thanks for the help! I have another question that perhaps belongs in another thread. I have two date fields: DateIn and DateOut. In addition, I have a Yes/No field. Can I disable DateIn or DateOut input based...

Maybe I should clarify what I meant. I envisioned several text boxes. One of the boxes would be solely to input a value to search a single field. There are hundreds of values in that field but each one is unique. The other text boxes would display the remainder of the entire record from the...

I have a very simple database where one of the fields always has a unique entry (not the key or ID field). I want to create a form where you enter a value contained in that one field, hit the enter key and all the details of the record show up. Further, I want all the fields for that record to...

I imported a large Excel sheet into Access. I also have ASP scripts used as an interface. The script generates the error "Type mismatch: 'EW_UnFormatDateTime'". I believe the original creator the Excel spreadsheet used a custom date format in some places and not others. My question...