Search results for query: *

Hi all, I'm trying to make an .exe using VB 6.0 to call an MS Access macro. I found the following code on the web. Set your project references to MS Access x.x object type library and try running this code: Public Sub RunAccessMacro(strDB As String, strMacro As String)...

HI All, I recently started working with the Access Runtime tool in Office Developer 2000. I've successfully packaged a database and also deployed it to a machine that doesnt have Access installed. however, when i run setup for this package in that machine, i get an installation error that reads...

Hi All, I have 3 sub reports each with different widths, and one of the sub reports is too wide for a letter size layout, even with margins set to zero. Normally i would adjust the content of the subreport to fit the main report. But in this case, i cant find any more space to give, and the...

Hi All, I have a spreadsheet with multiple columns that contains the same header. I want to write a macro that will delete the entire column with that header. here's what i have so far N(1) = "Pen %" N(2) = "LY R Sls " N(3) = "LY U Sls " N(4) = "Chg %" N(5) = "TY U EOH...

HI All, the database that i am using is getting to big due to the ole objects. I searched in the Access VBA forum and found that there's a way to display images on reports using a link. I am going to try converting my database to that but first i want to extract all the images i've stored on my...

Hi All, I am importing with an excel file that has a date column but as text format. all the values in this field is formatted as "mm/dd/yyyy" ex. "06/15/2007". i am stuck on converting this text string to a proper date in Access. many attempts were made by using a combination of dateserial...

Hi All, I am working with jpeg images in an Access database using OLE objects. i notice that once i paste an image onto a record, the actual memory size of the database becomes bigger. The database grown substantially as i continue to import more images. This is causing a problem because it's...

Hi All, I have a column of text, and i need to shorten them by locating the last ":" and taking all the text behind it. my thoughts lead me to use a combination of right() and find(). but the problem is that there are several ":" in each text. and find() only looks for the first one from the...

Hi All, I've been stuck on this for the whole morning. Public Function XLfilelookup() strFolder = "C:\EXCHANGE\XLfiles\" With Application.FileSearch .NewSearch .LookIn = strFolder .FileName = "*.xls" .Execute For i = 1 To .FoundFiles.Count...

Hi All, As PHV advised, i start a thread to better discribe my access query problem. I'm trying to rank style performance by two fields, EOH_U and ST. Please have a look at sample data Time Cntry_No Chnl_No Loc_No Div_No Style EOH_U ST 1Day 2001 200 0 1002 2007R023RQ3040 183...

Hi All, I'm stuck on a query. I'm trying to select records based on their stock position and also based on location. if the loc_no is less then 10, i only want records with more than 50 units. then if loc_no is >10, it can return all records. i'm using Access 2000, please help. here's what i...

HI all, I receive a raw file each day that reports on sales performance to ALL products in the whole business organization. The file is drilled down to item level and the hierarchy of how the data is categorized is by Store>Product Dept>item id. i want to pull the top 20 performing items by...

HI All, I have a report that has a SQL written in the record source. it's just a simple select statement that picks out records from a table, with it's records sorted by descent from one of it's fields. i want to limit the amount of records pulled by this query, but the Top Value function...

Hi all, everyday I run a stats report from an access database. And every once in a while (which often occurs in one of those busiest of days), Access will give blank reports when i go into the print/preview mode. usually, i would import raw data (text files). start a macro that runs the...

Hi, I have a report that have several subreports embedded. How can i change a label in the main header section to reflect the type of the subreports being reported? i.e. i have 2 subreports, one by region, one by store type... how can i make a label in page header of the main report to...

Hi, I been wanting to figure out a way to open and run an Access database from excel. i currently use a excel macro to reformat a text file to fit the formats and field names of my access database. after reformatting.. i would maually open the access database and run a series of access macros...

Hi all I have a database that will be distributed to other computers and use to run off other data with same formatting. in the pass i would manually reset all the file directories that links raw data (excel files) from local hard drives. But now i am trying to create a form that will prompt...

HI, i am stuck on this part: i ahve a cell with a range: a1 = 004-010 how can i list the numbers in this range? so b1:b6 = 004,005,006,007,008,009,010 consecutively... thanks hosackies

Hi all, well i am not sure how to describe this in the appropriate terms. so pls forgive me... here goes.. i have a table off from a query that has IDs and units. How do i group similar records together by IDs and create a difference between units... see illustration. (query1) IDs |Units...