Thanks for the quick reply, Bob. That is one of the articles I ran across. I registered the location of the DB as a trusted location and also registered a digital "SelfCert" certificate on the test machine, but still get the error. I have some added code behind the controls in addition to their...
I have an application written in Access 2007 that works fine on my machine, and worked when I originally installed it on the end-user's machine. At some point the controls on the main form quit working. It gives an error code of 2950. I have researched the problem and what I have found points to...
I have a list of client names in one column and a random number between 1 & 200 associated with each name. I also have a table of numbers, 1 through 200 with a letter designation for each number, (a,b,c,...aa,ab,...ga). I am trying to figure out how to use a formula to assign a letter(s) to a...
I am a VB.NET newbie used to VBA. I am trying to figure out how to compare a variable to the value input into a textbox.
I tried declaring the variable and setting it's value, and used nested If/Then/Else statements to compare the textbox values to the variable. Even when the proper values are...
Have another star PHV...your simple aggregate query was exactly what I was looking for!
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
I figured it out now...I used the "TransferSpreadsheet Method" but was copying the range of cells from the "Define Name" window and pasting it into the "Range" section of the code. That was the problem because it has the cell references prefixed with a "$". Once I removed them from the code, it...
I am pulling data from 2 separate A2k2 databases over our corporate network. Both DB structures are identical (excepting data). I accomplish this by using a make table query to pull data from one DB, then an append query to pull data from the other DB, for each table. I use this data for weekly...
Thanks, LittleSmudge! I didn't use the code you suggested, but thank you for pointing out what I obviously overlooked. The quotes were screwing it up. Have-a-star!!!
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
I am trying to get my front-end DB to compare a value in a linked table from the back-end to a value in a local table from the front-end. Below is a truncated snippet of my code:
===========================================================
Dim intLocal As Integer
Dim intLatest As Integer...
linuxjr,
The data access page sits on a server and does not need access for someone to use it. It is, in essence, a front end to your "back-end" database. I am in the process of trying to figure out DAPs myself and have found so far that they don't like combo boxes or tables without...
Cosmo,
"OR" is the correct operand. This returns a list of projects where if any component of it is not checked off, it will show up in the list.
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
Here is the SQL that I used:
SELECT tblWells.atoWellID, tblWells.strWellTechID, tblWells.OperatorName, tblWells.intQuoteNumber, tblWells.strWellName, tblWells.strArea, tblWells.strFieldBlock, tblWells.RigName, tblWells.dtmSpudDate, tblWells.dtmWellEndDate, tblWells.ysnOffsetData...
I figured out what I needed to do. It's along the order of +/-18 check box fields. I was doing the query in design view and decided to look at the SQL view. There I saw that I could change the "AND" to "OR" and have it work like I wanted.
Thanks!!!
Clint Galliano...
I have a table that has a bunch of check box fields. I want to be able to query for any records that DO NOT have all check boxes checked. Any suggestions?
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
Just a thanks to Tahoe2...pointed me in the right direction about a different problem. Removable drive setting up with different drive letter assignments depending on what else is plugged in at the time. It played hell with replication & paths for my split MS Access DB.
You gety a star for the...
I figured it out. Instead of having it on the "On Load" event, I triggered it from the "On Dirty" event of the first field. Works fine now.
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
I am using a custom, auto-incrementing value as a record ID,(read - not PK), on a form(frmNewWPAO). I tried using similar code but diferent reference values to do the same for a subform(frmServiceTicket) 2 levels down from the main form. (Form levels: Main=frmWPAO, sub1=frmWPAO_Order, sub2[of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.