Search results

Good question..I wrote the original a long time ago. It is supposed to open the subform The main form has a sub form in it. I actually tried taking that bit out like u r sort of suggesting,and it worked a couple times and then just hung. Thats why Im looking at putting the subform bit back again.

This code works fine in 2002,but just hangs in 2007 It appears to hang on the "ReSizeForm Me!myform1.Form"..in fact nothing happens at all. Quote Private Sub Form_Open(Cancel As Integer) ReSizeForm Me ReSizeForm Me!myform1.Form DoCmd.Maximize DoCmd.GoToRecord End Sub Unquote Taken a while to...

Sergeant Many Tks Using "Indirect" works great U just need to know the magic word :) Captnk

I need to look up a cell in another sheet using a row/cell reference in a different sheet. Ok so in say Sheet2 Column AM,in row 1 I have "D5" I need to look up cell D5 in Sheet1 (Sheet1!D5) At the mom its looking up the cell reference AM1. VLOOKUP(($AM1),Sheet1!$A$1:$BM$1000,3,FALSE) How can I...

Tks I will have a play around with that My Pc is also set to show am or pm time,however so far I havent seen any problem with it I had changed the previously suggested time code to: If Time > #9:00:00 AM# And Time < #11:59:00 AM# Then ........ Currently I am running the code from a module. Captnk

I raised this a while back and the solution works fine However I would like to look at another option. Instead of multiple splash pages,(one for each time/picture), is it possible to have just the picture (Within the splash page) change The picture is just centred within the splash as a .jpg...

Is it possible to set up a situation that say (depending on time of day,0900-1200 or 1200-1500,etc,)that a different splash screen will be displayed on opening of the Db. Captnk

I want the opening Splash screen to wait until the password is entered before it closes and goes to the programs main page I have tried using the .bmp with the same name as the .db which works fine (although just a quick flash),but I really want it to stay displayed until the password popup is...

Tks PDX_MAN U r so right !!!!!! It was picking up an earlier version of the query. I feel stupid,but u get to the point where u cant see the woods coz of the trees,and u simply lose the plot Captnk

I have an append query that simply appends to a table. When I run the query manually all fields in the query are appended. However when I run it thru a macro,it fails to append 1 field. The failed field is derived from an IIF statement in the query. However it doesnt make sense that it works...

Xl contains a function +proper(...... This converts the first letter of each word in a text string,to a Capital (upper case),with the balance of the word as lowercase. (very useful function) I can Access options for upper/lower case but this appears to be an all or nothing situation. Does...

I appear to have resolved the problem myself. Tks Captnk

Apologies,but this is a repost from excel section. Think I need more specialised VB help So I have the following bit of code (recorded with a macro) Cells.Select With ActiveWorkbook.PublishObjects(1) .HtmlType = xlHtmlStatic .Publish (False) .AutoRepublish = False...

I am having a problem exporting in the manner I need. Fields with a value are exported as: "name","make","etc", However where I have an empty text field it is seperated only by a comma: "name", , ,"make", I need to get the empty text field to read as follows "name","","","make", How can I get...

Tks Pat I have read yr previous posts under unordered sets. Finding posts is easy when u know the search criteria text :) Looks like it is a Relational db convention Unfortunately I cant have a number field or an index as this would effect the programmes that import the delimited files. At this...

I have been experimenting with exporting,delimited text files. I have noted that despite the fact the originating table is sorted in "date descending order",the resulting delimited text file appears in a random format (not in same date order),although it keeps groups of items (in this case...

Pono1 Thats BRILLIANT,it does excatly want I want Many thanks Captnk

Further to my first post,having done a lot searching,I guess what I am really asking is : Having created a textstring (Filename&filedate) ,is it possible(how?) can I export that textstring as a txt file

Tks ghudson I use Dos because I need to create .lzh files. This format is used for 2 programmes I have and the download data comes in .lzh format What I am actually doing is compressing daily file downloads into 1 large monthly compressed file. Anyway seeing u have given me some coding ideas I...

I have a "private sub Commandx_click() created In this Vb script (amongst other things),I create a "filename" comprising a name&filedate. I need to create a bat file that will let me run the compression prog LHA using the created filename. eg: lha a "filename" *.* Is their a way I can create...