Search results for query: *

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, 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, 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, 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!

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!

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!

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...

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...

Hi guys, First off I would like to thank you all for lots of good answers to my questions! Now, my question this time is how I get [FieldAverage] to calculate the average sum of fields that contains numbers higher than 0 in a form. I have 5 fields that contain numbers from 0 to 10 ([field1]...

Hi! I have a number field that contains time usage for a certain project at work. The time has been inserted into the field in minutes with no mask og formating. To sum up time usage I've got this query: qry = "SELECT Sum(Time) AS TotTime" & _ " FROM QryProject WHERE " & _...

Hi guys, I'm going to make a report which will contain a lot of results. Instead of running a query for each result, I want to have one big query that covers all results (this is more effective... or?) How can I put these two queries into one? qry = "SELECT Count(*) AS CountResult01...

I've made a report that counts my customers based on type and location (district). What I want is to use a form to deside which district the query should show results for. I'm having problems referring to the form in the query. Any help here would be great! The code is as follows: qry...

I'm using the following code in a combo box to search my customers: Private Sub CtrlCustomer_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[CustomerName] = '" & Replace(Me![CtrlSearch], "'", "''") & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End...

Hey you guys. Have a look at this. I've set up a seach function in my DB. The search field in FrmSearchCustomer filters out my customers like this: Private Sub CtrlSearch_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Name] = '" & Me![CtrlSearch] & "'"...

I have a two page report based on a predefined layout. Each of the pages layout is inserted as a picture in the report. Because each of the pages is 29.7 cm long, I need a couple of centimetres more than what is allowed in access. Is there some way to force the reports lenght? We are going to...

I posted a thread here about two months ago asking for advice on how to synchronize two identical databases. Replication was suggested as an alternative, and that looks like the best one too. I've been reading up on the subject, and I also made a test version of the database to try it out. As...

Hey there My form has an option group "CtrlOpt1" with 3 radio buttons, and a text field "txtField" below it. For every time i choose an option in CtrlOpt1, the value returned is sent to txtField. Private Sub CtrlOpt1_AfterUpdate() Me.txtField = Me.txtField & Me.CtrlOpt1.Value End Sub...

Hi guys I have three pictures 160x160 pixels in size that I want to put into my form. However, I want to control which image is visble through a text box. This means that if I type the number "1" into the text box, the first image is shown, when I type "2", the second image is shown etc...

right... I'm looking into making an object which changes between 3 different smiley-images, depending on which value I fill into the textbox "TxtValue". The values goes from 1 (happy smiley) to 4 (sad smiley). Any suggestions how I can solve this one? A line of code that I can continue work on...