Search results

I've been developing apps in MS Access for a few years now, but have not come across this error message. I took an app that I've been developing for quite some time, made some changes (nothing to the tools/references), performed a compact/repair, and saved the file to the network for a...

I read that we cannot reference a field from a form to enter a parameter within a pass-through query that references a stored procedure. However, could one of those parameters be a dynamic date? For example, below is what I have {call dbo.RPT_storedproc1 ( 'code1;code2', NULL, NULL...

i have a form with four combo boxes and two radio button boxes. combo_PR combo_PN combo_CC combo_FT each of the combo boxes above reference a field (respectively): pr pn cc ft for each combo box, I use (obviously changing the combo_pr and pr for each event): If IsNull(Me.Combo_PR) Then...

I recently migrated network-linked tables to a SQL server, and select queries run much quicker now. however, delete/append queries take quite some time (20+ minutes to run a standard delete query to remove 6000+ records). i've read that I may be able to increase the speed by creating a delete...

there is a stored procedure that I'm trying to tap into. input parameters have already been setup, but querying (using the input parameters) this stored procedure seems to only work in Excel. I would like to bring that query into Access, but allow the user to change the input parameters. for...

I have a query with an outerjoin; two tables (no subqueries). When viewing the query in datasheet mode, I am able to edit the fields. However, when viewing the query within the continuous form, I am unable to edit the same field. I am able to successfully add new records (and when adding new...

I have a continuous form with comboboxes that feed into a query. In addition to the comboboxes, I'd like to add a multi select list box that enables the user to filter the form (query results) based upon the selections. For reference, the field that I would like to filter on is also referenced...

For those that are having trouble deleting that ~tmpclp#### form or report that only shows in VBA module and NOT as an object in the navigation pane. I created a new blank form (but did NOT save it). created a button, assigned a macro to it and gave it the following code: docmd.rename...

trying this again folks since my prior thread (XPS merging) got zero responses. I soon realized that using the VBA code for PDFCreator will merge PDF files, so I can move away from XPS. My code is almost there. my only roadblock is that once each PDF gets sent to the PDFCreator Print Queue...

Hello all, I'm somewhat new to Access/VBA, and I'd like to add a button to a form that will merge all XPS files in one folder into a single PDF using PDFCreator. Given that all folks on the team that I support do NOT have Adobe Acrobat Pro, merging PDF files into one PDF is not possible (from...

I built a union query, combining the fields from table_A, table_B, and table_C. However, I want to exclude table_C only if the inactive_date is not null (data stored in a master_list table). This master_list table lists all of the tables within the database. I tried to insert some iif/then...

I found several threads on this topic, but could not find an appropriate solution for my issue. I created a database (frontend/backend) for my team where the frontend is installed on their PC and the backend table is located on a shared network. There can be as many 30 folks in the backend...

Hi all, I created a form with an embedded subform (continuous form). The main form (frame) has 15 buttons going down the left-hand side with the subform adjacent to them. This format works very well for my team and looks asthetically pleasing. The lone draw back is that some folks have a...

Hi all, I'm having some trouble getting my database to run a public function called "Export_as_Txt". I have the VBA coding setup as, "Public Function Export_as_Text()" both within the form's VBA code and within a module named "Export_as_Txt". I then want users to be able to run this function...

I have a form, within that form is a tabbed subform. within this tabbed subform is another subform (a table). The table is used for people to log information on a monthly basis. adjacent to this table are some text boxes with calculations in them tied to this table. I would like for these...

long time searcher, first time poster... i created a database and released it for my team (frontend/backend setup). however, most of the members on my team are getting #Name? or #Invalid on some dlookup formulas in unbound text boxes. However, on my version, I see the actual data shown. I...