Search results

Well I just tried this and it works, though I'm not sure if requerying every time the subform Enter event fires is overkill. Private Sub subformName_Enter() Me.subformName.Requery End Sub Note: my subform Name is the same as the subform control/container name.

Hi All, I have an unbound form with a combo box, a command button that runs an update/insert sql, and two datasheet view subforms (each bound). No defined Master/Child links and both subforms dataentry=No. The combo box value is used as criteria for the subforms and I have a requery both...

It turns out this is not just a single control on one report that the box would need to be made bigger. Its more like 100 controls x 5 subreports and the page space is already limited for printing as it is. I was really hoping there would be another option. I just don't understand why it is fine...

Hi All, I have a hybrid database with Access 2007 interface and a report with several subreports. These subreports display number data from tables (currently stored in Office 365). There is an issue with the some of the controls truncating numbers to #### (as if the control box is too small...

I am working on hybridizing our Access 2007 database FE+BE to work with Office 365 BE and Access 2013 FE as described here: http://www.devhut.net/2014/01/13/how...zure-database/ So far it looks promising for my small company but I am having trouble with finding information about how to...

I am using Access 2007. Text44 is unbound (I am not going to give it a meaningful name until I know if I can get this to work). Offset is a field in my table. When I run the report, the contents of Text44 display as "?Error" instead of showing data. Txtoffset is not empty. The report...

Hi, I have a text box named Text44 on a subreport. I put this statement into its control source.... =Left([txtOffset],7) txtOffset the name of another control on the same subreport with control source Offset. There aren't any other controls on my subreport named txtOffset, but...

gemma-the-husky - thanks so much for this. works brilliantly and is the most succinct I was able to find of all variations of this function :)

No, the report includes additional data from other tables linked by ID to the spreadsheets. We have an older set up that displays excel sheets as OLE objects and we got them to fit/display nicely on a regular piece of paper by formatting the excel sheet page size with a stand alone macro.

I am interested in approaching the employer with the idea of Attachements as a work around, but I NEED to be able to display the contents of a spreadsheet as a graphic on an Access report that will be printed on paper and handed over to the government (CORPS). If I can't find any info on...

Hi All, I am building a database in Access 2007 that needs currently includes images and excel files as embedded OLEs. I am aware this is not ideal, but I can't change my employer's mind. I've been looking in to the Attachment data type but am having trouble deciding if it will work as...

Got it! I did not end up implementing the code as in my previous comment. I still ended up with a double loop - the outside loop going through my combobox to pick up the Instrument ID for each excel file, and the inner loop going through a recordset to pick up the sensor ID for each sheet in the...

So looking in to the recordset - I am thinking about trying to implement my export this way... http://www.access-programmers.co.uk/forums/showthread.php?t=215859 Comment #9. Can I have my query live in VBA instead of in the database? I am not having luck calling the function in the...

I guess I am not seeing how I don't need the values from combo1. Here is my code, combo 1 is cboInstr and combo 2 is cboItem (I simplified terms in my original post). cboInstr determines the excel file, and cboItem determines each sheet in the file where data goes. I have queries set up...

Thanks CJ_London. That didn't seem to do the trick though. I also have noticed that it also won't select any value in combo1 if it is default with a blank value. This is not the case in previous versions of my code where the two combo boxes are not dependent on each other. Not sure of the cause yet.

I am running an export function from a module1 that contains a loop nested within a second loop. Each loop is running through items in a separate combobox on a single form1. The outside loop goes through combo1 items and the inner loop goes through combo2 items. My issue is that the value of...

Thanks for the reminder to error trap. I had to look it up again to get the trapping right - I had tried some earlier today and I didn't set it up right. Looks like I got my answer. Someone entered fake data in the other .mdb into the wrong field (still waiting on an answer from the tester...

I am having an odd problem. I have a code module in my interface with 3 functions that run via separate forms with user inputs. Each function is similar in design, exporting data from a generated query to excel for input into external software. The database is split into an interface FE...

Ok! I guess I was headed in a good direction. Here is the code that works as needed. Option Compare Database Option Explicit Public Function CreateQCChartsforReports() As Boolean Dim qdf As DAO.QueryDef Dim strSQLStatic As String Dim BookName As String Dim BookName2 As String Dim intCounter...

I am a relative newbie to VBA, and not very familiar with loops, but I need to add a loop to my function that exports a query with criteria contained in a bound ComboBox on a form. I've gotten my code to work fine without the loop, but I would like to export one file for each item "Team_ID"...