Search results

I have a simple form based on a one-to-one query on two tables. For some odd reason it suddenly started acting "strangely" and I have not been able to nail down why. The first field on the form is automatically selected (normal). When the form is open. The problem is that if you attempt to...

Evening guys, I have a user getting a runtime error on the below code (near the bottom "RUN LINKDB()" is where the debugger highlights. It works great on my computer but for some reason not on his. I checked all his reference libraries and they match mine. Any thoughts? The on load code for my...

I have a query that returns a percentage in one column. I have an open form with a text box that has a format set to percent and for some reason when I set the query criteria to point to the open form field using a >= it just ignores it. The criteria I am trying to use is as follows...

I need to check (through VBA) if a linked table is online or not. The linked table is attached to a SQL server using an ODBC connection string. If the server is offline or unreachable is what I am using to trigger other code. Anyone have ideas? I have been googling all morning with little...

I have been putting together a way to re-link ODBC linked tables through VBA in Access. At times our server name changes so this code will prompt the user to provide a new server name without requiring the user to get involved with the linked table manager or using a DSN file. Just tie this code...

Morning all, This is going to be a slightly long winded post since I am essentially asking for advice on the direction of my life lol. I am active duty military with 18 years in. My goal is to work in database development with a good amount of programming as well. So while my focus will be...

Has anyone ever seen this error when trying to trigger an email from Access 2010? "The operation failed. The messaging interfaces have returned an unknown error." The error appears in outlook when you click "send" on ANY email generated from within Access 2010. It does not change if you do...

I have a field that calculates a percentage and has an if clause to deal with possible devide by zero scenarios. The report shows correct in report view and even handles the zero or null values correctly in report view. BUT, in print preview the field still works correctly until it gets a devide...

Hi all, I appear to be working may way through my wish list today of "thing I wish I had time to fix", mostly due to help from all of you. That being said I have one more problem to toss at your collective minds today. I have an Access 2010 DB with a SQL server Enterprise backend. I normally...

I have a form with two listboxes on it. Both list boxes display a different set of records based on their own queries. The form wworks flawlessly with one problem. If one query has no records matching its criteria the entire form shows blank with no controls or anything. I know this is the...

Does anyone know if it is possible to scan all the code in all the forms and modules of an access database. Find matching string values and replace it with a user provided string? Essentialy I want to make a "find and replace" function that runs off a button click but will scan all the VBA...

I have been using these forums for a few months now and I thought it would be a good time to introduce myself. My name is Clinton and I work in an electronics industry here in South Carolina, USA. I am 36 years old, married with two kids and going to school part time. My degree plan is for a...

I have an append query that pulls records from one table and adds them to another table while inserting some default data. What I would like to do is make that same query or VBA tied to a button that will take the source table and create multiple copies of that record into the output table based...

I have an Access form based on a SQL server table. The table has server side permissions set to prevent view (Select) unless in a security group. So far so good, everything works as intended. HOWEVER, I am trying to trap the sql server select error and just display the msgbox I already...

I need to reference a shared picture in Access 2010s new picture library. Does anyone know what the call is in VBA to call a certain picture?

I have an access 2010 form that has VBA code to open a sharedrive location using it's network address i.e. \\SSC-FAS01\MATA\DBdocs\ It works like a champ regardless of who opens the link on our network. The problem is how do I enable people to change this address WITHOUT requiring anyone to edit...

Morning guys, I have a problem with some of my forms now that i went to Access 2010. I have spent the last two work days fighting this and neither myself or google has been able to fix it. I have reached the point of just trying to do a workaround. In this case I have a single form that opens...

I just upgraded from MS Office 2007 to Office 2010. Unfortunetly, I have an Access DB that uses alot of macros to change visibility of controls on and off. For some reason, none of them are working anymore and I cant figure out why. If I manually change a control to be visibility false then...

I was trying to get Lebans form animation to work on one of my projects. The form I need to get it to work on is called frmstartpage. I imported his sample project into mine and copied his on load and on close code from his sample form into the same events on my form. Unfortunetly, nothing...

Up until now I have been using remote desktop to log on to close to 500 machines on our domain and running a single executable that requires no input or interaction from me. I would like to know if anyone has seen any scripts to do such a thing automaticly. The closest I found so far was a...