Search results

hi all I would like to perform a query on several tables. The table has a field which contains a sales value. I would like to query this data and multiply or divide the sales value against another field (conversion factor) from a different table. Creating an extra field in the query - the...

is there a way to remove the pivot table total / filters and windows standard grey boxes.. i want a plain table with a few grid lines... rgrds

ok im getting there..... runs over dos using text file.. not sure how to run this from vb also how do i get the IP address of the file destination....??

mis-read that last bit.... dont need to input data - so i will look at a cross-tab query i done a search for flexigrids, cannot not churn any results - do u have any links + info

i assume the excel spreadsheet will have to be open to loop the data back onto the form. i developing forms for a users and rather them not have to worrk about other programs being active. the flex-grid looks promising... i dont want the users to input data.

i have given up with the pivot table.... 1# because its ugly for the users 2# i want something in a datasheet type view - spreadsheet like is there any other way to solve my original question - flipping the layout? someone suggested: extracting the time period with the sales data i need...

what do you mean....? are you suggesting having a sepreate table for every product..

sorry.. this is all very new to me i can use vb from access to run this text file i create...? what commands does this text file use? are these some sort of commands that control windows? how would i run this file from vb? an example would be much appreciated... im going round in circles...

so for example: webAd = http://download/file username = hello password = enter would i simply write: open webAd username password wot syntax is involved - is that it?? (just type username, password - dont i assign it or use some type of argument)

Hi i got help with fetching files from the internet in the past - only just got round to trying it out - see code below this openIPnr - what is it and how do i use the syntax.. im searching the help files but cnt find anything have u got example code so i can use the syntax.. many thanks...

Hi I have a table : i.e. product 1 / Date1 / sales Qty product 1 / Date2 / sales Qty product 1 / Date3 / sales Qty product 1 / Date4 / sales Qty i want to present this in a different style on the form, using a scroll bar to view records not on the screen: i.e: Product1...

REFER TO ANOTHER FORMs CONTROLS FROM EVENT.....??? Hi I have developed a form (MainForm), with a subform (ListForm) which contains a listbox displaying records on the main form - is a button which launches another form (WzdForm). The WzdForm will hopefully provide the capability to re-query a...

Excellant!

REMOVE ACCESS PROMPTS i.e. want to import? hI i have automated a process where data is imported by the click of a button. I have achieved this... but one thing which i find annoying is a prompt from access - 'Would you like to append 126 rows?' I would rather the user didnt see this! is...

i am also downloading csv as well as txt.. will this effect the shell..?

Do you have some kind example.... so i can get an idea of sntx etc or provide some commentry on what those instructions are doing.. _______________________ 'open IPnr (is this the point where u specify the internet address) 'username, password - my accounts will request user name and...

the file names will change - they tend to use a fixed name and a variable number which seems to increase after each download. i.e. 'download-00902.txt' so i could attach a varibale string to get the name of the file

the filename IS likely to change! I think the files will always be on the same address, its a user account type structure where your favourites files are loaded and you select the file and download. Because i download so many files i wanted to somehow automate this process.. is this possible...

Hi Is it possible to enable a user to simply press a button, with some magic - files are downloaded from a web address? i have no knowledge of whether this is possible.... can anyone provide sources for info or an example...?? regards

Hi I am using a tab form - i have placed a floating sub-form which display continous records from a table. The table has a field which identifies a record of being one of 4 types (wah, wrh, weh, wch) Ideally - i want a user-friendly tab system (a tab form per type (i.e. wah) - so when then...