Search results

Hi, I might not have been clear enough. The report will always have a record. The text box I'm referring to is a mailing address text box with one or more names, one or more street address, etc. Therefore the height of the "printed" text box will vary. I want to immediately follow the...

Hi, I have a report with a text box that expands and contracts based on the amount of data it displays. It's Can Grow and Can Shrink are set to Yes. Immediately below the text box in the design view is a sub-report. I would like it to closely follow/be immediately below the text box and move...

Problem solved; it turned out much easier than I thought. In the forms Current event, I used Me.NumberToUpdate.Requery and it works perfectly! I didn't need any of the other events. Geesh.

Hi DBG, It works, the only issue is that it takes longer to recalc the form than requery a field, which is annoying when there are several rows to update. Do you see a way around this?

Hi, I have a Continuous form. On each row there are two fields important to this question. One if a Option Group and the other is a date field. At the bottom of the form is an unbound text box with the following control source: =DCount("*","[Count Work Completed]"). The DCount works...

Update, problem solved. On the main Switchboard, on the data tab of the properties, there is an option "Allow Edits". It was turned off. Turning it on allows the sub form to be able to accept changes to the options. I'm not sure why a setting like this on the main form impacts the sub form...

Hi DBG, I add the subform to the real main form by just dragging and dropping into the design view of the main form.

Hi, I have a form with a sub-form on it. The sub-form is not bound to the parent/main form. The sub-form only has one contol on it, a Frame with three option buttons. If the sub-form is opened by itself, I can pick any of the three option buttons. If I place the sub-form on a blank form, I...

Great idea. I’ll work on this today between rain drops, the Indy 500 and a cookout. I always appreciate your feedback! Take care.

Hi DBG! The user will have to do a "Save As" in Word after they finish editing the document. The code below, 1) works like I want it to 2) but hasn't been cleaned up, (work in progress). It opens a template with the company's logo and other key information from the Access

I am using Access 365. I have a form with a command button on it that opens a Word document and takes information from the form and places that information in the Word document using Bookmarks. It works fine. What I would like to do is when the user finishes editing the Word document and is...

DBG, please check your email.

Well, Sugar-Jets!

[VendorReferenceNo] is a field in the underlying table for the query. In that underlying table, a value for [VendorReferenceNo] might be something like, "LAR0910" In the [Locations] table, the value of [InvPrefix] will either have a value in it or it will be empty/blank. In my example, I'm...

I have a query that has a DLookUp function in it with criteria but it's not producing the results I need. The DLookUp is- TEST:DLookUp("LaborRate","[Locations]","[Location Code]='" & [RepairLocation] & "' AND '" & [VendorReferenceNo] & "' Like [InvPrefix] & '*'") [RepairLocation] and...

NG, thank you, (and everyone else). I'm swamped fighting another problem and haven't been able to devote time to this problem that I still want to solve. NG, can you upload your sample db and let me take a look at it? For everyone, I have an employee table that has a sub-table with the name...

Mark, first, I apologize, I've been wrapped up on another project, but still need to solve this performance issue. To answer your question is number 2: Each person has individually designated permissions for each control. You cannot see the control unless you have permissions to see it. More...

dbGuy, on another forum someone posted: Well, if you are in off-line mode, and you have the cache turned on, then that user should be able to freely add records. The PK will start at -1, then -2 and so on. You could check for a internet connection, but if they are flipped into off line mode...

It was 3027 which indicates the db is read only. I think that's because the SharePoint lists are off line. You're right on the cached but that's the problem. If the user clicks on the command button more than once, it appends the records, (in the cached mode), more than once. Then when...

I was observing a user of the db I built and saw something I didn't consider. I'm using Office 365 for Business and the Access front-end connects to SharePoint lists. The user clicks on a command button which starts vba code to do several things and towards the end, runs an append query. The...