Recent content by jco23

unchecking "Microsoft ActiveX Data Objects 6.1 Library" appears to be a more permanent solution. hoping this doesn't break something else.

i think we may be on to something. we removed one reference, added in another, and then moved it as high as we could go (third from the top). then, we noticed on one of the modules that it read: Option Explicit Option Compare Database when those two are normally reversed. after adjusting this...

yeah, we reviewed the order of the references, and they are exactly the same. we tried replacing newer references with older ones, but to no avail.

i'll look, thx

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'll give that a shot, thanks!

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

right.... this table only has one index, but this is to be performed by non-admin users going forward, so I need to keep permissions in mind... I'll try the insert logic. thanks again!

I would like to append data from a local table to a SQL server table. my current append query has the standard logic, but takes several minutes to append 6000+ records. I have not set up the append query via PTQ. side note, using delete mytable worked. not sure which is better between...

i'll give that a try.... thx! would there be a quicker way to run the append query, or am I stuck on that slowness?

thanks for the quick reply - yes, I did. i'm somewhat familiar with writing PTQ. I was merely stating that the old delete query was tied to a linked table.

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

disregard - I was able to find a work around by setting the form to allow edits on the load and/or the form_current event (me.allowedits = true). this also allows me to determine who make edits and who cannot.