Search results

I'm not sure if i understood right but i'll try :) You can have the records in a query group by the address and also get the count of the address (how many times one address appears in the database) . Then write an if statement in the query Expression1:if count(address)>1;("Mr & Mrs...

Hello, I'm trying to build a report for mass printing of all the applicants i have in a database with their items they should apply. Below i descibe how i designed the report. I have a specific page header (Application Title) that appears at top of every page in the report. Then i have an...

Thank you for answering! What i need to do is to prepare a script that merges two databases into one (something like replication). When the user gets both databases from diffrent location, i want the script to put them into spesific location and merge them. Macro will run all the SQL commands...

Hello, Is it possible to create a script which will do the following? 1. Copy file1.mdb from location A to location B 2. Import Query1 in file2.mdb to location B 3. Import Macro1 in file2.mdb to location B 4. Run Query1 and Macro1 in file2.mdb Any ideas? Thank you in advance!

Hello, I searched the forum but i haven't found anything, it there a way to make text alligment set to justify (as ms word does it)? I use distribute but it's not effective with dynamically set text. Thank you in advance.

thank you for answering! What value should i assing in cancel if if clause is true? if <clause> then msgbox("You are not allowed to save the record.") cancel= ??? end if

Hello, If <if clause> then ' can't save record end if How can i prevent the user from saving the record when <if clause> is true? I'm using a continious form and i want to prevent save only in those records that <if clause> is true. Thank you in advance.

Thank you... i will try it!:)

How can i use conditional formatting in a combobox and have the condition in column(13)? Condition1: Sururb.Column(13) equal to -1 Thank you for answering!

Hello, I have the following lines of code: If Len(cbo.Column(13)) > 0 Then If Suburb.Column(13) = -1 Then Me.Suburb.BackColor = 255 End If End If When column(13) becomes -1 in one record i want the combobox sururb of that record to become red but with the above code i get all records red...

I had in my SQL statement the ORDER BY clause and that was the problem. I removed it and now it works just fine. The Combo filtering from http://www.databasedevelopment.co.uk/examples.htm. works as well! thank you for your help:)

Does this method works for ODBC connections as well or it's only for access? Because i tried it and i get the message "ODBC -- call failed".

I will try this... thank you!:)

I have a combobox that loads data from a table with 60.000 records. The source table is not local, is linked from SQL Server with ODBC. I save the combobox value into an access linked table. The problem is that is taking too long to load the data into the combobox. Is there anything i can do to...

I will try the user_round function. Thank you for your help :)

I use the same version as you. You have right, if i try 3.215 i get 3.22 but when i try 3556.425 (or other numbers) i get 3556.42. That's strange, I don't understand why :( This is the example from msdn: http://msdn.microsoft.com/en-us/library/se6f2zfx(VS.85).aspx

Hello, i have a problem with function round. Result 1: round(3.215,2) --> 3.21 (fuction's result) Result 2: round(3.215,2)-->3.22 (wanted result) Is there a customization to round function in order to get the second result? Thank you in advance.

Hello, these are data from a query i have and i want to create a report based on the query with a chart as following: Date Score Average 1/1/2006 45 50 1/1/2007 43 48 1/1/2008 56 32 Axes X -> Date Axes Y -> Average Type of chart -> Line Lines ->...

First of all thank you for your answer! :) I'm not sure i undestood what's your suggestion. My problem is that I have a flowchart designed in Smartdraw and i want to have this flowchart as report where the values will change according to record source. First i tried to export the flowchart as...

Hello, Is it possible to have a PDF file as background to a report? I tried to convert it to an image file but the resolution it's pretty bad. Any ideas? Thank you in advance.