Search results for query: *

I’m having problems printing a report from a set of combo boxes. I don’t know if it is even possible with the current table structure. Table tActivities have columns that include StudentID, FallSport, WinterSport, SpringSport, ConcussionForm, ActivityForm (this particular report shows the...

I've been away from Access for years and simple things seem to baffle me. DoCmd.RunSQL "INSERT INTO tStudents (StudentID) VALUES (StudentID) " The Student ID is an Integer. As I close the current form I want to insert the StudentID value into the table tStudents Column StudentID Any help is...

I have a generic report that prints from a form. On the form I have multiple command buttons that print the report based on a criteria. I want to add a report name in the header based on which button is clicked. Can I add it somewhere in the command line. In the example below if vevent23=-1 then...

I've upgraded Vista to Windows 7 and can't seem to export and import my pst file. I'm using Outlook 2007 in both applications but the Windows 7 installation is 64 bit and the Vista is 32 bit. Could this be my problem?

How do I change the phone number input mask to have a fixed area code. Most of my area codes are the same but I want the ability to change one if needed upon entry. Thanks

I have a password protected flash drive that will not work with only 1 computer. When I plug the drive into other computers they read the bat or exe file and run the password software just fine. When I plug it into the one computer the drive registers in my computer but when you click on it all...

I use the following to determine if a file is open or not. The column CaseFileClosed is a yes/no data type with a check box. It has worked fine until I started re-opening closed files. I think when I re-open the file it is changed to 0 or 1 (can't remember which) instead of a null. What...

I have the following formula in a text box. I know it isn't really close but it is the eaisest way to explain my needs. I would like a total of all [actRegHours] from the table tabActivity where [actActivity] equals "Court". =IIf([actActivity]="court",Sum([actRegHours])," ") Thanks, Jeff

I have a form that is driven by the following query. I would like to be able to edit one column (VehiclesInvestigations.RecoveredStolen) and change it from no to yes (it is a Y/N checkbox format). When I try and do that it beeps and will not change the box. Do I have something out of order...

I found the following code to disable the insert key. What would it be to make sure the insert key is "on"? I do set the key preview to yes in the form. Thanks, Jeff Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyInsert KeyCode = 0 Case...

I know this is right in front of me but I can't figure out how to get the computer name or login name into a string. Any help is appreciated.

I have been using the switchboard manager to conrol menus on my database. I know there are better methods out there but I'm not ready to convert or create new menus yet. Recently, when I try and add a new switchboard command invoving forms I get a "for loop not initialized" error. I only get...

I use the following code to take information from a group of unbound text boxes on a form and insert them into a table (tabActivity). My problem is that if any of the number variables are blank I get the Invalid use of a Null error. I have to make sure zero's are in all number fields for the...

=Format([inDate],"ww") I'm using this formula to find the week number of a date but I cannot figure out how to change the start day from Sunday to Monday. I found this syntax for the Format function but can not seem to make it work. Format ( expression, [ format, [ firstdayofweek...

I recently installed a fresh installation of Vista Home Premium on a new hard drive. I kept the original drive with all my data (and the original vista installation) as a data drive. No matter what I do, the old files are all read only and I can't modify anything. I have removed the read only...

I'm currently having a problem with a yes/no check box that somehow stopped working. I have a query that pulls 3 columns from one table (the one that contains the yes/no column) and 3 columns from another table. Before I add the second table to the query the check box works fine. When I add the...

I have a report that consists of 10 sub reports, one directly after the other. Occasionally, the last line of the page is split in half horizontally with the other half being on the next page. It seems to happen with such irregularity that I haven't been able to nail it down. Until I can, has...

OK, this INSERT command is going to be the death of me. The underlined code keeps opening "enter parameter Value" boxes wanting input of vInvNum and vVehID. When I run the cursor over the Dim areas the correct values are shown. To get to this code the vehicle license number must exist in the...

Here is my current roadblock! The table tabCaseFileSuspects contains all the suspects related to a case. When I open another Investigation (many investigations to one case file) I need to insert the existing suspect(s) information into the new investigation. Because there can be different...

I just recently updated to Access 2007 and it now seems that I can't change the specific printer in reports. I have a few reports that I want to print to WinPDF but when I make the changes in the report it doesn't save them. I don't get any errors, it just doesn't save the change. Any known...