Search results

Hi all I have placed a bitmap image ontop of a button: the plan was to; 1) when the mouse is not near the buttons the image is displayed ontop 2) when the mouse moves over the button the image visible property is set to false, displaying the buttons caption 3) so when the mouse moves...

quality... first of many i hope... i will keep the royalties in mind

hi im planning to see a database i have devloped do you have any guidlines for doing this - do i need licences etc? thanks

im using a cross-tab query TRANSFORM SUM(FIELD AS TOTAL) ...... select from group by The field i want to format is the value being totalled... i cant get the vb in the previous post to work... my results are just an empty listbox ive tried various was to use the vb... i.e...

my sql is: ListBox.rowsource = ("Transform sum(TotalPoints) AS Total" SELECT allmyfieldcolumns FROM mytable Group BY oRDER BY Pivot...

sorry to ba a pain... could you explain the formula please - whats the [calculation] bit? - do i use this in the select - part of the sql ?

ive found how to specify the field format in the query - i cant find any changes in the sql after the update - im using sql in vb, how can i specify the field format to show 1 decimal if required, if not then just the whole number

sorry - didnt make it clear, i have queried from the table using a cross tab.. how do i specify the format for a field using a query?

Field decimal property ....?? im using the field decimal property as 1 - however when data is appended to this table it doesnt display it as 1 .... 0.00000000 this figure is created using a calculation does it inherit it to the updated table or something? i tried even changing the...

Ive tried various properties for the field in the table which is displayed in the list box. in the table im seeing 0.0 formats but in the list box 3.6666666 for some values and 0.0 for others I havnet used : Format([fieldname], "0.00") i simply typed this into the field format...

Hi Im using a query to extract data from one table to append into another. i then query from the second table to perform calculations and to display results in a list box... the results i want to see are numbers with 1 decimal point I have tried setting data types to decimal...

Hi I have designed a database - i wish to distribute this to a number of users.. # i dont want them to have access to vb code and design am i able to provide this so its not installed as a program - instead its run as normal from an access version

Hi all Im using a graph on a form the graph plots quantity against dates the gaphs table has some null values against dates im using a line graph and the line tends to join all the dates regardless that the value is null i want the line to stop where nulls exist and start again at the nearest...

i tried opening the text file in Excel... im assuming this runs a similar process to access when importing i use the same specs, delimited and text qualifier "" all the data goes through fine...?

Hi I am automating the import txt file process using vba. For some reason one of my files will not import without errors. the file contains sales quantities with dates across as coloumns i.e. ________________________________ product date1 date2 date3 date4 1 2 3...

thats great... the example makes it a lot clearer, i will give this ago.. im still not sure about the IP thought, do i need to find out the IP of the server or can i use the website address??

ok, i thought it might be something to do with the US.. ive got it working thanks!

im using vb because ive developed some type of wizard form which querys records to display in a listbox from user input. im then attaching the sql to the rowsource of the listbox. so i can actually define the format of the date in sql....? i will try that.. ive just noticed that if i write...

Hi I have used sql in vba to retrieve records between 2 dates. i.e. between #02/04/2003# AND #06/04/2003# (ddmmyyyy) The dates in the underlying table is set to general. However, for some reason the records retreieve do not reflect my criteria.... instead i get records between...

thanks very much..