Search results for query: *

thanks dhookom, I'll try out your suggestion and post the result. I initially tried to put a textbox (txtSub1, txtSub2 etc...) next to each subreport with control source "=[Page]". This gave me the page numbers I wanted. It was a long shot, but I tried to write some code that would copy these...

Hello everyone! I'm building a report with 5 subreports in it. Each of the 5 subreports is divided by a page break in between. The reason for using these subreports is that I have to include a lot of graphs in the report, and each of the subreports is based on different tables. Now, I'm also...

Hi gyus, Thanks for all your input. Here is what I have tried: 1) Had a look at system and user logs, nothing related to my problem. I also made my own custom view and included all logs and all types of messages. I then tried to open different items on the control panel, and looked for any new...

Hi, After searching the web for a solution to my problem without any help, I turn to you guys. I have three HP DC7900 with Windows Vista. They have hardly been used and have never been connected to internet/LAN. My problem is that I cant open several items on the control panel. Ex. User...

Hi guys... I've been doing some more testing. I have been closing the form for each time I open it in different data modes. The buttons event goes like this: DoCmd.OpenForm "Form2", , , "[ID]=forms!Form1.form![ID]", acFormReadOnly '(or acFormEdit or acFormPropertySettings) It seems like the...

thanks dhookom! The reason I ask is actually to try to work around a problem I have encountered. I have a Form1 with three buttons that opens the same form, only in different data modes; acFormPropertySettings, acFormEdit and acFormReadOnly. The problem is that when opening the form in...

Hi, A simple question :) How can I save form changes (not record changes) with a command button? Lets say I have a code that sets Me.Detail.BackColor=vbRed, and I want this change to be permanent. I've tried the following, which does not work: Private Sub btnChange_Click()...

Hi, The database does not know the filenames, only the autonumber that is manually inserted before the chemical name in the file. The autonumber is separated from the chemical name with a #.Is it possible to make a code that disgards the filename, and only looks for that autonumber in the...

Hi, We have a database at work with a register of all the chemicals we use on a daily basis. Each of these chemicals comes with a pdf document specification. All of these documents are stored in the folder C:\chemicals\pdf\. What I'm working on is a way to connect each record in the database...

Hi guys! I was just wondering if there is a third party application that can work as a out of office assistant in outlook? We dont have an exchange server solution at work, and we need out of office. Thank!

Hmmm... that didnt seem to do the trick. I might have to give a better explanation of what I want to achieve. I'm working on a report that's going to gather data from inspections done at our clients sites. We do these inspections at multiple sites within one week for each customer. Each site...

Hi, I'm using this "current week to date"-query: SELECT Table.DateField FROM Table WHERE [Table.DateField] BETWEEN DateAdd("d", -((Weekday(Date()) - 1)), Date()) AND Date(); How can I get this SQL statement to go one week back starting with [LastOfDateField]? Thanks!

Sorry, my mistake! I CAN use code, this is afterall a form. Thanks so much for the help!

Thanks dhookom! From what I understand, there is no way to do this in the table field options? The subform that contains "NC1" is shown in datasheet view, so there is no way to use code to solve this.

Hi! I have a table (TblRegist) with a field called "NC1". The content of "NC1" repeats itself over an over, and I whould therefore like to set the fields default value to the same as the previos (must be previous) field in the table. I'm sure you guys know what expression to use here :) Thanks!

Thanks Tony! HP recommends this card when using three monitors, but I cant find more info on how youre supposed to get this to work! frustrating!

Hi, I'm currently trying to set up my computer with three monitors using extended desktop. Here is what I've bought: - HP DC7800 with Vista Business (on-board Intel Q35 Express Chipset Family graphics card) - 3xHP L1950 monitor (DVI and VGA input) - ATI Radeon HD 2400XT (256MB DH) PCIe Graphics...

Thanks for quick response :) When refering to the CaseID-field in frmCustomerSub, I have to include "Me!frmCustomerSub!CaseID", right? If I dont do, I would basically say that the CaseID-field is located on frmCustomer and not on its subform.

Hi! I have three forms: frmSearch (Based on a query, contains a control [CaseID]) frmCustomer (With control [CustomerID]) frmCustomerSub (With control [CaseID]) Here is what is supposed to happen: When I press button btnNext in frmSearch, the value in frmSearch!CaseID is passed to...

Yes, this looks like what I'm after. I've been trying it out, and I have to admit that I'm kind of a newbie. Could you perhaps show me the code with my fields inserted into it? Thanks!