Search results

I have a split form that recently developed a problem. when the form first opens, the active record is record #0 , I have no record 0 in my database. However, on the displayed form it shows the data for my first real record. and in the split (datasheet) portion of the split it shows all...

Hi, I am having a problem with 2 of my forms. I have made many forms in my DB but only 2 have this issue. They are both POPUP and CONTINUOUS. The problem is, when I hover over a button anywhere on the header or footer, the button appears to "jump" sideways about 1/4". It also leaves a...

Hi, I have a split database where many users use a local copy of the front-end. MS Access 2016. All users using the system are using Citrix virtual desktops on a corporate network. One of my users is experiencing a problem when emailing a report as a PDF in Outlook. Except for this one...

The font for all my forms and reports have somehow changed to a different font. Text is now too large to fit into it's boxes and, in some cases, I have no room to accommodate the larger font. It may be connected to an upgrade from Office 2013 to Office 365. Has anybody else experienced this...

I want to open a form from vba and only view records where a the certain field is equal to 4. my syntax.. DoCmd.OpenForm "frmWO", , , "WOStatus = 4"When the form opens, I see ALL records. I'm sure I've used the right command, haven't I? Any thoughts?

Hi, Having a tough time with this one... I have a report with a subform. In the subform, there is an unbound textbox (six actually but they all work the same) that I use VBA to alter the text and formating of (based on certain conditions). I also use the subform in another form as well. FYI...

Hi, I have two fields, one is a numerical value, and one is a date code (example: "2","ww" meaning 2 weeks, or "4","m" meaning 4 months) I want to sort these in a query by shortest to longest duration. I was thinking of converting all of them to days and sorting by days. I don't know of...

Just wondering how, from a criteria in a query, I refer to a field that is present in an open subform record but has no control associated with it. I've tried [forms]![MyMainForm].[SubformControlName].form![MyField] that doesnt work. As far as I've been able to conclude, that only works...

Hi, I have a query which is essentially a quey of a junction table and its fields. It is the recordsource for a subform which displays its data in "continuous form" style. Of the 2 objects it is junctioning, one is a union query. In the junction table, I also have independant fields which I'd...

I'm trying to make a variable(QTYA) equal to an integer value in a textbox. The textbox is on the subform. To me, it looks correct. But it's not working...It keeps equalling 0 regardless of what the textbox value is.

Hi, I'm trying to compare 2 calculated numbers in a Subform to see if they are equal. If they are equal, I want to make a textbox visible. I cant get it to work. I'm running the code from the main form, but I've also tried from the subform, with the same result. There are no errors, and it...

HI, In a continuous form, After a requery, I'd like to move back to the field and record I was last on. I've managed to set my focus back to the previous record, but I can't figure out how to mark which field I was on.

I'm trying to figue out how to set the focus of a form to a certain field when a record is new. Is there an event for this?

Hi all, I'm trying to sort a continuous form by clicking a button a the top of the column to run VBA Code. I've got this working to sort based on one field. I'm trying to sort based on 2 fields (date, name) so it could look like this when I sort by date first: 1-1-2012 john wall...

I'm trying to use a button click on a form to open a second form to a certain specific record (based on the value of "textbox5". I've managed to open to specific record using the openform command (below). The problem is that it filters as well, so that matching record is the only one that shows...

I have a button on my form, when I click it I want it to add a new record with the same information as my current form and subform. I do have code that is almost working (see below), but I just cant seem to get the bugs out. I can get it to add a new record, but then it seems that it won't...

Hi, I have the following syntax in the criteria field of my query: Like [Forms]![PurchaseOrders/Estimates Form]![Text90] & "*" I've used this to filter by the textbox "text90" as you can see I also have a wild card after the text90. What my question is.....What is the proper syntex for...

Hi, I've got an issue with my querys. I'm trying to use a button on my main form as a "Search" button. it works well when I'm searching the main form, but when I use the same technique to search the sub-form, it returns a main form record for EVERY subform match I just want to see each main...

Can't seem to get a grasp on this. Here is what I've got so far... Private Sub topdf_Click() Dim blret As Boolean Dim stdocname As String stdocname = "print and email report" blret = ConvertReportToPDF(stdocname, vbNullString, "x.pdf", True, True, 150, "", "", 0, 0, 0) End Sub When I click...

I'm having trouble with some cascading Combos on a form. They seem to cascade fine, and record the ID keys in a table. The problem is, when I move to an old record, info doesn't display in the bottom 2 comboboxes until I click on "Refresh" from the "Records" menu, then the data appears. What...