Search results

Yes, you should be able to update your many records in the subform and your 1 record in the form.

Create the query from your table putting in all the fields you want displayed. In the query user name field criteria put: Like "*" & [forms]![form1]![text0] & "*" In the above code, forms is calling your group of forms. Form1 is the name of the search form that you'll create...

Hey all, I pasted this code into a module and called it in a form "on open" event: Option Compare Database Private Sub Form_Open(Cancel As Integer) Me.Visible = True fSetAccessWindow (SW_HIDE) End Sub now, whenever I open the form in question it gives me an error: it is...

Is this exported txt file going to be used to populate a pdf?

This was exactly what I was going for! You sir are a genius, thank you so much for helping me through this problem and teaching me something new!

This is what I've tried thus far. It does set the height to zero like it should but the can grow and can shrink settings to yes don't collapse the remaining displayed buttons. Private Sub Form_Load() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM TblUsers...

Thank you all for your help! both ways worked but it seemed like TJPoorman's method requires a lot less typing. Another question for you guys. If I wanted to collapse the space for the omitted buttons to keep everything racked and stacked nice and tight would it be possible? It is a form and...

^^^This is my issue and I'm not sure on how to go about writing it. I want the code to lookup a record utilizing the EDIPI then search all the yes/no fields in that record. Any yes/no field in that record that is yes I want displayed and the ones that are no don't display. I need to correct...

Hello all, I'm having some difficulty running a Private sub. every time it loads, it gets a run time error "2465" (can't find field 'l1' referred to in your expression.) Info to help you all get what I'm trying to explain: Table name = TblUsers It has 26 fields: EDIPI = unique ten...

Ok, I have gotten the thing figured and also, how to condense the data to make the list continuous without large blank areas between selected fields to be generated in the report. If DCount("*", "[TblReqAcc]", "[AdditionalDutyRoster] = '" & Me.AdditionalDutyRoster & "'") <= 0 Then...

Because the report is a catch all for DB access rights. The report is generated from a table that has all the fields included. There are roughly 20 yes/no fields that populate in the report whether they are yes or no. Yes actually populates as yes while the no's are blank in the report...

is this possible to do like dao.recordset but instead of doing it to the records, do it to the fields within the record?

What the end results I'm going for are... If the information is blank in a field then it doesn't display on the report, if the information is there then it displays. That way the admin won't have to go through and sift thru all the areas that are blank or not. it will only show them the areas...

I have a report (RptReqAcc) that I generate from a table (TblReqAcc). TblReqAcc is a temporary table that only holds 1 record at a time. It has a lot of fields contained in it (which are listed below): TblReqAcc: FldUserName (Datatype: text) FldRequestDate (Datatype: text)...

Figured it out! In case someone else runs into the same situation: In the query field, to change the created tables checkbox field from binary to text and have it display Yes instead of "-1" I did this: TblFieldName: IIf(Int([forms]![FrmUserRequest]![TxtbxUserName])= "-1","Yes",)...

Int() was my next guess but it changes the value from 2 question marks to -1. is there a way to mask how it displays... ie: IIf([table]![tblfieldcheckbx]= "-1" , "Yes") I don't know how to write that and my first stab was just as displayed above and that was a nogo.

Hello all, I have a make table type query that runs from a button on a form. The form is an unbound form that allows new users to provide their info to the admin to register an account. So basically, when the user fills out the form, they click a button and it runs a "make table" type...

would it be possible for you to set the default value on the date box to =Now() or whatever format you prefer?

I would build a macro for the "on click" event to save record, refresh and then close form. Then try and go back into it to verify it is taking.

What is the macro for the "on click" in your save button properties?