Search results

I took over an old Co-Workers Program and there are some people wanting a few changes. The only issue I'm having is on a report that is pulling from a few Queries. Its pulling the sum of the Total Time field When the Type field = AO. Well now they want to also be able to see the sum of the...

I have an Access front end with a linked table to SharePoint. There are only 3 Fields. Number Name REV Everything is fine for the first 4,500 records. But for some reason, the last few 100 are missing the Number. Its so weird. The items are on SharePoint. If instead of creating a...

Hi.......... I added in some email functionality to one of my program which now will not work for the one user who happens to have a 64 bit version of Access. I know what bit of code is causing the error and I was wondering if anyone new what I need to change in it so that it will work for 64...

I have an Access program on Citrix that has been working just fine. First thing this morning everyone was able to print. But all of a sudden around 10ish, a message now comes up for everyone when they try to print that says: "Before you can use the feature, OneNote must start for the first...

I have a program I'm running off the server with no issues. More then one person can be in it at a time. But if I add a linked table to SharePoint, only one person can be in it at once. It pops up with an error message saying its locked and currently in use. Is there away around this?

We have a new engine coming soon and the guy who wrote the LabView program for our current engine has retired. I've been tasked with coming up with a program for the test bed for our new engine. I see that we can read/write to an Access table with LabView so as of know, I'm going to make the...

(Sorry if this is in the wrong place I didn't see anything for Power Point and I really think its an Access issue more then Power point but I'm ok if it gets moved) I have created a Power Point slide with a few graphs and text boxes. I want to place a button on an Access program that will feed...

I have recently moved a program from running off our server to Citrix so remote users can use it. Its working amazingly but I found while making the transfer, it didn't like to reach out to Outlook. When a form was created, the program would send out and email to the next person to let them...

My company is about to spend a lot of money on third party software that can read the data coming from an ECU to a CAN adapter. Is it possible to use Access to get that data in a usable format? I don't see anything on Google about this.

So I have a word doc with some text boxes that I make a copy of and add data to. It has been working just fine for at least two years. And it still works correctly on a second program. But for some reason, all of a sudden the line of code .Visible = True is causing an error...

When I use: If .Fields("Nomenclature") = "" & a & "" Then Me.List2.AddItem (.Fields("Nomenclature") & ";" & .Fields("MaterialNumber") & ";" & .Fields("LogNumber") & ";" & .Fields("CreateDate")) Each record correctly finds it way to the list box. But when I use: If...

This morning I tried to get one of my programs up and running on Citrix and after about an hour of people using it, it locked up and we could not get in. I think it locked up because all of the tables are local. It was designed to be a font and back end program but I could not seem to link...

In my load form I have: DoCmd.RunCommand acCmdWindowHide DoCmd.ShowToolbar "Ribbon", acToolbarNo And it works fine for about 30 different users. But for some reason, for 3 users, those DoCmd lines cause an error. It says "You can't carry out this action at the present time" "You...

So I have a few programs on the server that are 2010 and when someone opens them using 2013, I guess converts it, and no one using 2010 can use it anymore. I know I can use SysCmd(acSysCmdAccessVer) to get the version. Can I put this as the very first line of code the program sees and if...

I have my Access Tables hidden but I just realized that in Excel, on the Data tab, then clicking on From Access, I can select the program and then select the tables. If I already have them hidden, how else can I go about stopping Excel from seeing them?

Man it seems like the company just went to 2010......... I have a lot of programs in 2010 and just last week a user for a new program had 2013 and the program did not load correctly. This is going to start to become a real issue and I want to try and get ahead of it now. I'm sure...

I use the code below to take a preformatted word doc, open it, save some information to text boxes and then save a copy of it in a different folder. Dim appWord As Word.Application Dim doc As Word.Document On Error Resume Next Err.Clear 'Set appWord object variable to running...

I have an excel spreadsheet that I import into Access. Once in a while I get a Runtime error ‘3349’ I think the problem is that the user makes a mistake when filling out the spreadsheet and does a Cut and Paste. Access does not like the field that was Cut. I’m able to figure out what field it...

I'm working with two different Data Bases. One is just an Access Table and the other is a list on SharePoint. I'm trying to take the SharePoint list, run down one field and take each part number and compare it to the Access table to get the description and then place it on the SharePoint...

How do I close a .pdf file using Access code? There has got to be some simple line of code that will do this. I know the location of the .pdf. There has to be something like: CloseFile(filePath.pdf) I've looked and looked but cant seem to find the answer.