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...
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...
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...
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...
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...
We have Adobe Acrobat 6.0 Professional set up as a pseudo-printer for our applications, like Excel, Word, etc. Generally, I have no problems with it but one Excel workbook got corrupted some way and I can't print out the entire workbook as pdf; I have to print each page individually then merge...
My basic question is how to make a query show a message box before it runs. I tried adding the final MSGBOX line to the SQL below for a simple querey, but it says I'm missing an operator. I tried putting OPEN before MSGBOX but that didn't work either. How do I get the query to show a message...
I have a 17-column table in Excel which I want to import to Word, retaining the links for probable updates. When I import to Word, with the page set to landscape mode, it truncates the last few columns. Adjusting column width has no effect; we still lose the last few columns.
How can we shrink...
Does anyone know of a source for an Access function which returns the phase of the Moon for a given date? Something that I can download or cut-and-paste into a module would be ideal.
The function should be something like
MoonPhase([date]) = p
where the value returned, p, would be a...
I am importing data from another application into MS Access; the name field in this application is in the format "Lastname, Firstname". The length of Lastname varies from one record to another.
My application has separate fields for Lastname and Firstname, so I want to break the name field...
I have a MicroSoft Access database which generates tables which are exported as text files for input to our accounts payable system each week. I'd like to put the current date into the name of the tables and files so that I can keep copies of what's sent, instead of covering up last week's file...
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.