Search results for query: *

I have an Excel spreadsheet with drop-down menus for start date and stop date. After choosing them, I want to calculate the number of days in the chosen period. Just subtracting begin from end doesn't work; 3/31/14 - 1/1/14 = 01/04/00 when calculated from the drop-downs. =datevalue(3/31/14 -...

I was writing a program in UBasic, the Basic version modified for number theory work, and couldn't remember the proper format for the modulo function. I tried googling for help but it seems that since I last used UBasic several years ago, it's been adapted to operate cameras; I couldn't find a...

PHV: We get Run-time error "2501": The PrintOut action was canceled. When we click the debug button, it takes us to the code and highlights the PrintOut line. dhookom: That looks like an alternative but I'm curious as to why some of them work and some don't, even though all have the same...

My database prints several different types of labels. We start with a separate form for each type where the user enters the data to go on the label. Before printing, the user enters the number of copies needed in a text box on the form. Although the coding for the print button is the same on all...

Good thought but the names are still the same as before, no changes. I opened a new, blank database and imported all of the objects from my current database into it. The MainProjectList table opened in this new database without asking for parameters from the ProjectActivity table. The original...

I have a database which suddenly started asking for a parameter value when I open a certain table. The table is called ProjectMasterList, with the Project name field as a key field. There is another table, called ProjectActivity, which is linked by referential integrity to the ProjectMasterList...

I imported an Excel table into Access. The rows were projects, the columns were week-ending dates, and the values were the hours spent on the projects each week. I would like to unscramble this table to the atomic data bits that make it up, one record for each project-weekending-hours...

The form is open and all fields are filled. I ran it this morning, and everything seems to be working again. I shut down the database, re-opened, and it still worked. I'll try again this afternoon and let you know what happens.

SELECT Formulas.[Formula Name], Formulas.[Kcal Per Unit], [Forms]![fInputForm]![Text2] AS Expr_T2, [Forms]![fInputForm]![Text4] AS Expr_T4, [Forms]![fInputForm]![Combo7] AS Expr_C7, [Forms]![fInputForm]![Option34] AS Expr_O34, [Forms]![fInputForm]![Text14] AS Expr_T14...

I'm writing a database with a simple form with 12 fields. Some are text and some are numeric. I have a select query which pulls the data from the form and just shows the value of each field. When I write it, it works fine. I save the query, close it and re-run and it works fine. If I shut down...

I want to put a button on a form which will first open a new record and then unlock a field which is locked in the form when viewing existing records. When I create a button from the form design toolbar, it has a macro but I don't know how to get to the code so that I can build the unlock...

A new problem just popped up the other day. I'm running Win7 and for no apparent reason, the icons on my desktop which link to programs like Excel and Access or to specific files stopped working. I double click on them and nothing happens. This morning, I shut down the computer before going to...

I'm using Excel to track volumes on various medical procedures. When the volume reaches or passes a certain level, let's use 100 as the example, I want to enter that date in an adjacent cell. I can do this by the formula below where the volume is entered into cell B6: =IF(B6>100,NOW()," ")...

I converted from MS Access 2003 to the 2007 version about a year ago. Recently, I've had occasion to design a couple of forms and reports for a small utility database. When I use the wizard to generate them, the fields and labels are frozen in place, I can't move them around when I switch to...

I converted from MS Access 2003 to the 2007 version about a year ago. Recently, I've had occasion to design a couple of forms and reports for a small utility database. When I use the wizard to generate them, the fields and labels are frozen in place, I can't move them around when I switch to...

I googled about this but got no answers that worked, so I thought I'd try here. When you type a new URL into the Address window of MS Internet Explorer, it gets added to the list and stays there forever. I'm using IE version 6.0. How do you clear those out? The Tools/DeleteHistory doesn't do...

Thank you, it works perfectly. No more double vision! Paul

A few months ago I had a second screen installed on my PC, which is running MS Windows XP Professional, Version 2002. I should have done this years ago, it makes life much easier. I would like to have a different desktop background on each screen instead of the same on both and there's no...

I imported some data into an Access table but one of the fields is goofed up. It's supposed to be a diagnosis code but for some reason it came out with random blanks in the field. For example, "abcde" might be "ab cde" one time and "a bc de" another time. I asked if they could re-run without the...

I discovered the problem. The print quality was set to 300 dpi for some pages and 600 dpi for others; not sure how that happened. When I made them all the same, the entire workbook printed out to Adobe without any problems.