Recent content by bbrendan

Hi Pat, thanks for your help. You pointed me in the right direction. Ive just put some code behind the after update events forms!frm_main.refresh This refreshes the whole form, like the docmd does. cheers

Hi All, I need a little help with trying to re-query a mainform box Heres the deal. I have an order entry form which is made up of 2 forms, Main form and Sub form. The main Form has all the customer information, and order total fields. An example of thie is [Order Total] The subform contains...

Hi All, Ok this is something im REALLY stuck on. I have a file which uses the pipe delimiter. The problem is this, I cannot use the docmd.transfer text method as this requires a specification, which I cannot provide as this is a Access ADP, which doesnt allow you to store a spec name. So, is...

Hi, Im stuck here. I import data from our website via a csv file. This is all ok. Except we have people ordering from around the world, and I get these different keyboard characters.! Like On the website the Address line reads: Ark Fýlm Ltd.StÝ. but when I download into my table it turns...

hi, I had the same problem with Outlook security patch. One way to get around it is to use CDO see this thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=28669&highlight=cdo cheers

Hi RV, that seems to have nailed it.. thanks to both of you

Hi Newman, that works fine. Except If I have a number like 10.00 or 2.00 then it just shows up as #Error cheers

Hi Im need some help here!! I have a number field in access for example 12.99 and I want to convert this to text 0000000001299 I have used this: Format([amt_payment],"000000000000") But I get it rounded up to 0000000000013 any ideas?? thanks brendan

Hi, Thanks for your help. Will try this later cheers brendan

Hi, I have this code below where it queries a table. What currently happens is If BOF then stop. But I need it to say Ok not records in this table let continue on to next statement. like .... If mydb.BOF = true then Exit Sub 'This just stops the routine. What I would like to do is If...

Hi All, Im sort of new to VBA but need some help. What I would like to do is loop through a table and grab the results and populate them into my text string like Available in the Following Colours: White Mist Grey Ivory Peach In my code, I link to a colour table and grab the colour and link...

hi Travis, many thanks for your initial input, you pointed me in the right direction. Anyway, for anyone wanting to know in the future here's my code -------------------------------------------------------------------------------- Option Compare Database 'Define fields and Sizes Private...

hi travis, thanks for you reply on this! I have slightly modified your code, but get an error 91, "object variable or with block variable not set" any ideas?? thanks --------------------------------------------------------------------------------- Option Compare Database 'Define fields and...

Hi All, I need some help regarding importing a fixed width text file. Does anyone know how to programatically import a fixed width flat file into an MSSQL table. Note I cannot use the docmd.transfertext, as I am using an Access Data Project ADP. As in ADP it doesnt allow the use of the...

Hi All, Ok. I have built quite a complex Access ADP program to import website orders. I have many Stored Proceedures used but they are all hard coded to the specific databases which makes it a nightmare when trying to test this ADP on a test database, becuase I have to change all the...