Search results

Tried that, the repair failed with an error and didn't complete.

Went to: HKEY_LOCAL_MACHINE -> Software -> Microsoft -> Office -> 11.0 -> Delivery -> I have 1 line and changed the CDCache from 2 to 0

I did change it to 0 then I get the Error 1311. The reason I put it here in Access is my Word and Excel work fine its Access that is having an issue. What do I do with Error 1311?

I downloaded a trial version of Microsoft 2007 down onto my computer, put it in another folder so it didn't over-ride my 2003 I have. Now I uninstalled the 2007; I open my Access 2003 and I get the error that SKU011.CAB can not be found, this is a real pain and really need to resolve it...

I think my questions is fairly easy but can't seem to figure it out. I took a report that use to be in Excel and made it in Access but if there is one line of results it prints the 1 line with formatting around the boxes while the rest of the page is blank. Where in Excel you can format the...

On most of my report I have used conditional formatting of fields but I don't think I can use it on these others because I need to check if ActBeginDate is null and then if so make the backcolor of JobBeginDate accordingly but this is not working. I am using Access 2003, I do notice when I do...

Here is an issue and a challenge. I have a form containing 5 unbound boxes for the user to enter in a number or defualts to * and the results are shown in a list box below. Works, works when I am working in Access but then I run it in Access Runtime 2007 all works well expect when I change 1 box...

I had this exact problem too with Access Runtime 2007. The form I had coming up I put all the same code (minus his in red) before anything else and still had issues. So I took the previous advice created a new form that housed just this code, went to my autoexec macro and placed opening this...

I have exported data out to MS Project via VBA in Access into a Project template now I would like to add code to Save the file as whatever I designate. Current code: Public Sub exportMSProjectTasks() Dim jobNum, Fn As String Dim JobID As Long Dim app As Object Dim varFileNames As Variant...

I have a field JobNum (i.e. 6465) that I need to find its folder on the server but the catch is the folder has the year (08,09,etc) in front of the JobNum. How can I skip the first 2 digits of the folder and compare just the next 4 digits to find a match? Is there a way to take in the folder...

I have a module that runs when a command button is clicked it essentially deletes tables, imports tables (don't have them linked because MAS200 even though you tell it to remember the login and password when linking still asks you to enter it when using the table in any way), then I have queries...

This module worked fine until recently and now cannot figure out why. I mode the whole database onto my desktop and execute the module (becuase it deletes tables, imports new ones out of MAS200 an accounting program, then runs queries). Does what its suppose to but I put it back on the server...

I hope someone can help me with this Can I export data from Access into a Microsoft Project template? In the database they do have basic Project information, i.e. Task, Start Date, End Date so I am just looking to export those into Project. Is there some code I can write that automates this...

This one worked perfect and to the first posted reply THANKS I forgot about switching to use the expression - I haven't done this in a while for Excel or Access.

I have a form based on a table which in design view looks like 1 line but in form view has multiple lines because depending on the ID number depends on the description. What I want is when the form opens that the background of the field ID to change to blue if the ID = 9, 12, 19, 27, or 30...

I was trying to do this without the use of a command button because we have several forms. The previous programmer has some modules built that has something to do with default printing but I don't think anything is calling the functions.

I don't know if this is possible or not but worth a shot. Some of our users here when they have a form up they want to print it so they click the print button on the toolbar or right-click and select print. For some the page comes out nice and fills up the page, others its really small in one...

I have a query that clears out check marks before form closes but I want it to be automated so the user doesn't answer the question "Do you want to run query", "Do you want to update X records" how do I write that in the code? Thanks!

I have a main form with calculations and a subform with that has continuous lines and in the footer of the subform is a sum text box. On the main form I have a text box that references the total text box in the footer of the subform. So when the form loads and closes it runs through a procedure...

I ended up putting: Me.subfrm_Special_Total.Requery Me.Refresh in the main form, works fine but I noticed with my subform when I have say 10 lines and the subform is shrunk and can only show say 3 at a time there seems to be a timing issue of the subfrm total box updating versus if I made the...