Search results

Hrmm, im sure there used to be an Excel forum, i seem to have lost it :/ Hope its ok posting here: What im trying to do is, for a range of dates from 1/1/2005 to 31/12/2020 get the Qtrly Financial Period before... So, for instance: A date of 1/1/2005 makes the period before 1/10/2004 to...

Sorted it, i didnt know you could have empty strings in a IN statement, that dont effect the outcome. If Me.Check16 = True Then strB = """B""" Else strB = """""" If Me.Check22 = True Then strF = """F""" Else strF = """""" If Me.Check24 = True Then strW = """W""" Else strW = """"""...

Hi, i need to build a string to go into a "IN" statement, im changing the .sql of the query in code, and then opening the updated query. The in statement is built up from 5 Check boxes, depending on what box(s) you tick, the string will be of variable options.. These are my checkbox holding...

Ok, again ignore my previous comment, here are the Public Variables i have, the last one is the Only Const currently. The ones above that are the ones that have values depending on where you are in teh forms, these are the ones i need ot keep. Public intClient As Integer Public strClientName As...

Ahhh, dammit i just noticed what i have done. I have just put Public strTitle, and not Public Const strTitle!! I need to wake up i think :) Ta for pointing it out inadvertantly!

I have a number of Const Variables in my database, ranging from strings to integers. However, when im testing, if i hit a code error that isnt caught by my error trapping, it will clear all of the Public and Private Consts. is there anyway i can get it to keep the values, until they are cleared...

Sorted it, after 5 hours in total doing it! With rstVisits .MoveFirst Do CurrentDb.Execute "INSERT INTO [TEMP_VISITS] ( [HH1_MV_VISITS_ID], [HH1_MV_VISIT_DET_ID], [HH1_MV_VISITS_DAY], [HH1_MV_VISITS_START], [HH1_MV_VISITS_END], [HH1_MV_VISITS_ADDED_ON]...

Hi All I have written this SQL statement, in VBA to copy data from one table, into a temp holding table. While it copies, it also changes two fields to different reference numbers: CurrentDb.Execute "INSERT INTO [TEMP_VISITS] ( [HH1_MV_VISITS_ID], [HH1_MV_VISIT_DET_ID]...

Hi All Ive had a good search around the forums, and it seems this does get asked quite alot, i found this thread http://www.access-programmers.co.uk/forums/showthread.php?t=28541 which helps me connect to the server and execute the SP, however does anyone know how i could also send Parameter's...

I have tried using the code below, but now it updates all the records with the last records item descrpition. Using DeBug.Print i can see it does get each Different Item Description, but it just doesnt want to assign them seperatly... i guess that's because its a continuos form :( 'Select...

Hi Ive got a continous forum, with several fields on there. They all look at the same table, and are populated after a OnClick event. However, there is one field that is there, but its not linked to anything on the table. This is the description of a piece of equipment, only the Description...

Thanks for all the advice, im going to do some work on it today so i will take all your points and try to get it to work :) As for what the user insisted, that doesnt come into it. I think the exact spcification was "A Database for my shop" lol :)

Ive always set them up with a Unique Record, its not necessary like you say, but i like to have one :) Hmm, but now you mention it i might get rid of it. As you say its really not needed, and this is 1 table of 9 (Sport, Clothing, Eyewear, Footwear etc) similar ones.. so its alot of extra for no...

Thanks for your reply, but its not correct :) Table 1 (Customer) is set up like you have it. Table 2 (Sports) is set up like you said in your reply. It has Sport ID and Sport Name Table 3 (Customer > Sports Relationship) has Reference Number (Unique for that record in that table), Customer ID...

Hi All, i think its going to be a For Each statement, but i could be wrong :) Im setting up a small database, its got 2 tables at the moment, table 1 is Customer Details. Holds Name, Address, Contact Details and the like. Table 2 is a "Sport" table, basically lists the type of sports that the...

Done it! :) With the above code, i used .HTMLBody instead of the normal .Body. Works like a dream! Ta for the advice :)

Putting the HTML tags in doesnt seem to work. It just puts a piece of text in there with the tags :/ I thought i coulduse the more advanced sending emails code, with the OutLook.Application variable and setting. In the options there is an olHTML type, but im not sure if i can declare the type...

Hrmm, im not sure on the HTML status of both email clients. I think our work defaults them all to plain text... i'll test it and see :)

Hrmm, sounds like a plan.. What are the tags?

Hi all I have a piece of VBA code, that sends out an email with a couple of links on it to files on our network. The email explains what the two files are and then has the two links. Above each link is a line saying something along the lines of: Please Click Below To View The Finance Report...