Search results

Cheers Bob that is a great help, much apprecaited. Rob :)

I need to identify in the data coming in that the postcode is in a valid format and that it is a postcode at all, there is no master table to reference against. The space missing is not the only problem but the one I need help with, if the post code is incomplete or not a postcode I can identify...

I need to import data from a dbase file and during the import I need to check that the postcodes are in the correct format, we have postcodes like ST15OTJ when they should be ST15 0TJ also we will have ST10TJ when they should be ST1 0TJ. Does anyone have any code or clues on how to check these...

This database does not use a workgroup, its uses the basic password from tools/security/set database password its all it needs. Though I am assuming no workgroup is associated?

Hi All I am looking to find some code that I can use in a batch file to compact an Access 2000 database that has a database password set on it. I know about "C:\WIP\SPOC\OneCall_BE.mdb" /compact but need to find a way to pass it the password. What it does at the moment is open and waits for...

It doesn’t matter if it is xlt or xls file as it is just using a blank template in this instance. I have now resolved this issue by switching to using a docmd.transferspreadsheet command, perhaps not the cleanest solution but it’s working.

I have an issue with a 2000 database running under 2007. It works perfectly in 2000 and uses code I have used many times and at one point worked under 2007 but all of a sudden it won’t. It stops at Set wb_obj = xl_obj.workbooks.Add(Application.CurrentProject.Path &...

Fixed it Dim stDocName As String Dim stLinkCriteria As String stDocName = "Assets" stLinkCriteria = "[SerialNo]= '" & Forms![Items at Branch]![Items at Branch SUB FRM].Form![ItemSerialNo_Field] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria I Knew it must be a simple fix. Cheers :)

Hi I tried your code and it retuened [SerialNo] = CZC7534VDM So I changed code do it passed just CZC7534VDM but it still won’t work. You can tell is Monday. Cheers.

I am trying to open another form from a double click on a combo box and it won’t work, I have done this before without problem but for some reason it won’t play. It’s giving me a headache, Help. Dim stDocName As String Dim stLinkCriteria As String stDocName = "Assets"...

I expect there is an easy answer to this I have a form with a sub form which is a datasheet containing criteria to use to open another form, easy stuff double click on the first field and then the next form opens filtered to that criteria no problem there. The form with the datasheet has an...

Hi All I need to calculate the period between two Now() dates, fine one from the other and subtract the weekends (business days) but I need to show the result in Days, hours, minutes and the current answer is in metric i.e. 5.72. How can I convert this to normal time? Cheers.

Nice one Bob that did the job loverly, thanks.

Should be the time in seconds since midnight of January 1, 1970 Theres probably an easy way of doing this but I can't see at the moment.

Hi Anyone out there have some code to convert a access now() field to a unix timestamp? Cheers.

Nice one Ken, spot on that sorted it. What a silly mistake to make I must be getting old.:D

I got a problem with a date field, in the table it is fine showing ‘04/10/2007’ and the form the same but when I call this field from my code I get ‘30/12/1899’ I’ve looked through the forum and tried the suggestions found and no good. The table field settings are Format = Short Date...

I have a problem with sending a report as HTML via Outlook 2003, or to be correct two problems. 1. With memo fields it is not taking all the text, it is not grouped so it is getting past the 255 chrs. 2. If the report goes to two or more pages then it puts a First, Previous, Next, Last...

>You can sort or group on a Text field or a Memo field, but Access only uses >the first 255 characters when you sort or group on a Memo field. This answered a problem I had, I could'nt work out why I was only getting 255 characters off a memo field. Even though the answer was'nt for me...

Found this great code in the forum by Hayley Baxter http://www.access-programmers.co.uk/...ighlight=email that allows you to send a report in html format as the body of the email, this sorts my problem. :)