Search results

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...

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...

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...

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...

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...

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...

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"...

I need to add a DLookup to my Subreport. For my text box, Text255, on the Subreport I have tried: Private Sub Report_Load() Me.Text255 = DLookup("[Along_line_spacing_%pass]", "Performance_Requirements_Defaults_Table") The table Performance_Requirements_Defaults_Table has just one record...

I have a report with a nested Subreport. Main Report>Subreport1>Subreport2, for simplicity. I have master/child set up for both Subreports, but I would also like to filter the Subreport2 records with a date range parameter. Is there a way to get the Subreport2 where clause to recognize the...

I am trying to build a function that will create a dynamic query for a chart on a Subreport. I am not exactly sure I am going about this the right way, but I need the user to be able to change selected fields for use in the query. I have a form with 3 combobox controls for selecting options to...

Can anyone help me understand why I am getting "Compile Error: Expected: =" here: Private Sub Form_Load() Me.Text9 = DLookup("[Along_line_spacing]", "Performance_Requirements_Defaults_Table") when this: Private Sub Form_Load() Me.charttypestatic = DLookup("[Static_Chart_Type]"...

So I am adding a chart (on a subreport) to a report that has multiple subreports already. I have gotten the chart to show up correctly on the report, but now 2 of my other subreports are not working. I am being prompted to input parameters for these subreports that used to pull their parameters...

So I had this code working and then I cleaned it up a little and it no longer works. It should export data from a created query using criteria selected by the user on a form and put it into an excel file that exists. I get no errors but it does not export anymore. After pouring over it for a...

I am trying to use the string value from a form control as the criteria for a query. I first need to replace the "," in the string with "AND". So far I have a module using the Replace function, but it doesn't seem to be working. I am not sure I can reference the string inside the form control...

Hello Everyone, I am hoping for some advice about upgrades. I am a Power IW, and its been a couple of years since I've done any developing with Access. My company has tasked me with doing research on what to do moving forward with Access since we are upgrading machines (thankfully we will be...

Hi, its been a about a year since I've worked on database design, but my employer has a database that was created by a previous employee around 5 years ago and it needs some redesign. I've searched to see if I can find anyone with a similar problem, but haven't had any luck so I thought I would...

Hello everyone, I am having a compatibility issue with my database that seems to be stemming from my report queries. I am using Access 2007 and have a database that is saved in 2000 compatibility mode. The interface needs to be in both Access 2007 and Access 2003. When I open the 2000 version...

Hi there, I have a form with its underlying query built from a table. Users access this form by entering a date when prompted. I am having trouble fine tuning the criteria to prompt for the date because underlying field in the table is date/time (general date) - formatted like this: i.e...

Hi All, I have a question about adding a specific message box to my code. When users click a button on a form, a dialog box (using the FileDialog filepicker) allows users to select multiple excel files to import into a table. The file picker stores those file names and then...