Search results

Base the report data source on the query. Report will update automatically with the query data. Once the user has completed the form to input data into the query - just add a button to open th report. Note: an incomplete form --- causes --> incomplete query --- causes --> incomplete report.

Does it work in print preview? Apparently conditional formatting doesn't apply to Report View.

Personally I would consolidate in a query, then run a report off of the query. 2 tables: 1. tblSem holds Semesters StartTerm EndTerm Spring 1/2/2013 4/19/2013 Summer 4/29/2013 8/16/2013 Fall 8/26/2013 12/17/2013 2. tblCourses holds Course DateStart course1 1/3/2013 course2 10/3/2013 course3...

If you use the function (requires you to add the code of the function above) provided by billmeye - use If you want to try my quick fix - use SELECT Left([Field1],InStr(1,[Field1],"#") - 1) AS Expr1 FROM Table1;

Just drop it into the query interface and take a look to see if its what you want.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.numbers > 5 Then Me.Box2.Visible = True Me.Box1.Visible = False Else Me.Box1.Visible = True Me.Box2.Visible = False End If End Sub Why do boxes show up in print preview, but...

Regular expressions is used to manipuate text. But it has a bit of a steep learning curve. Try this instead: Left([Part Number],instr(1,[Part Number], "#") - 1)

Just figured it out at the same time you posted. I kept sticking conditions into the on open of the report and it wouldn't recognize anything...

I have a table w/field: Number {1,2,3,4,5,6,7,8,9,10} I have a report based on the table containing: 1 field: Number, box A and box B. I would like for the report to show Box B if Number > 5, else show Box A. How do I do this?:banghead:

Replace() doesn't work with wildcards. Maybe try regular expressions.

I have 100 txtboxes. They're labeled "MyTxtBox001", "MyTxtBox002",..."MyTxtBox100" I want to use a defaulted formula "=[Name]" or "=ActiveObject.[Name]" or something to that affect.

Thank you for the feedback. There's never any problem recovering from the corruption - and plenty of backups have been made. I would, however, like to minimize repeat occurrences of corruption since any time a recovery is necessary, the end-users are unable to access the data. The...

Drats. Current work around is below -- if anyone could reccommend better, please do so. Public Function that returns the name of the activecontrol. Default value = FunctionCall()

This is actually a surprisingly difficult question to answer comprehensively :) I recommend the following solution: http://allenbrowne.com/appfindasutype.html

I want to refer to an objects properties in form: ie... set a textbox's default value = textbox.name (me.name?) How do I set this in the form's default value (...without using VBA).

This might work to an extent. Hide portions of the form by section. Encourage the end-user to get used to "pseudo-forms" by section, while speeding up initial load time by hiding some initial visuals...

You don't have permission to access one of the tables you're attempting to access. This could be a table in access. Or a table in SQL Server. It could be application specific - something in access prevents you from reading the table. It could be network specific - you do not have network /...

Consider doing the following: sure - add a checkbox to your table and form. (note: unbound checkboxes won't work well) ---- pseudocode below - you may have to adjust it for it to actually work. form on open: if me.chkbox = true then me.customer.locked = True checkbox on update: if...

While I agree with you - and I am working to change the current paradigm - several teams want a single form with full viewable content. No pop-ups, no tabs, and denormalized data entry (think: textboxes for customer A, customer B, customer C...). Controls aren't really bound to any table -...

I have an extremely large data entry form (think 500 - 600 various combo/text/chkbox objects). Despite personal objections, all objects must be present in a single visual end-user form. .... In terms of load speed, processing, form automations and vba -- what is the fastest and most...