Search results

I have not run into this before, and hope there is a solution out there. Table1 contains 6 fields - fail1, fail2,....fail6 Table2 contains 2 fields - Code, Description I want my query to JOIN on fail1, fail2..... to CODE and have the 6 different descriptions show in my query output. I can...

sounds like you have the answer , though I'm not sure where/how this would be done. Thanks

Hi all, I have a form that is used to Enter and Edit records. At the end of a record is a "shipped Date". This is blank until the item ships. I want to make the entire record editable up until a date gets placed in this field. Is this possible? and can editing of the record still be done...

got it fixed! needed to use a report based on a query that did not PROMPT for input. made copies of the existing query and report then removed the prompt from the query and made my form button point to the new coy of the report.

I think I know why its asking me for UNITSN, The report ahs a subreport in it. in the report the Child is "UnitSN" and the Master is "TLAUnit" can i somehow get the "child" into the code, so it doesn't ask anymore? Kevin

Ukraine82, I tried your way and it prompts me for the UnitSN ( which is the current record) any way areound the prompt? Rich, I also tried yours and still get the same Syntax error. any other ideas I believe string is correct as the fields contain both letters and numbers (text fields)...

Good morning All, I have a form with a command button to open a report ( based on a query ) for the currently displayed record. here is the code I have used: Private Sub CS_notes_Click() On Error GoTo Err_CS_notes_Click Dim stDocName As String stDocName = "InternalSNwithRMAprodMASData"...

Works Like a CHAMP! Thanks!

I have a form that is used to both Enter & Edit records. There is a "search" button to aid in finding records. I have been asked to have the form open to a blank record instead of the first record in the table. Is there a way to do this without setting the "DataEntry" property to true, as this...

This is the first time i try this and just want to double check this. Running a make table query DOES NOT change the data in the original table, correct??? I ask this because, when i run it, a message pops up stating " you are about to run a make table query that will modify data in your table...

I found the problem (unsure why though) line: rs.find "TLAUnit='" & CStr(InputBox("Enter Unit S/N", "Find")) & "'" needed to have "TLAUnit='" be: rs.find "[TLAUnit]='" & CStr(InputBox("Enter Unit S/N", "Find")) & "'" not sure why though, I have 3 other DAP's that used the original line...

Hi all, I have a DAP off of a table, that i added a search button to (code from microsoft, see below) This works fine for the 1st DAP i did. <SCRIPT language=vbscript event=onclick for=search> <!-- 'Clone the recordset. Dim rs Set rs = MSODSC.DataPages(0).Recordset.Clone On error resume next...

I have been toying with this: in a form, scan the data to an unbound control then move the data to my bound control with --- =left(unbound,6) This works on the form, but doesn't write the data from the bound field to the table. Thoughts?

yes this is being done trough a form ( maybe a DAP in the future) Kevin

almost again This is the last item keeping me from posting my DB as complete ( which makes this even more frustrating!) is this an expression that should go in a form or table? in an event procedure or a validation rule? Thanks in advance

almost there I thought I just forgot the = sign. but i think i missed something else. would this go in the validation rule box of the table, or do I put this somewhere else. If i put this is the validation rule of the table, when a user scans data that is over 7 characters i get an error.

users are using a hand held scan gun to enter data into a field. if the barcode is 12 characters long, I only want the 1st 7 to be written to the table. I was thinking a validation rule using TRIM or LEN but can't seem to get it to work. Any ideas? Thanks

Good Morning all, I have a report that I have field called "MBModel". this show up on one place. I want to use that same field somewhere else but have it show something different (If that makes sense) I was thinking on the second field to use =IIF([MBModel] = MB06042, "VIA C3") Its not...

Thanks!! I just started using Access for much larger projects and this forum has been great!

Good mornig all, I have a field in a report, "memory". If this field is = to 901111, I want the report to display "256 Meg" instead of the 901111. Is this possible? Thanks