Search results

Hi All I need some solution if someone can uggest me some help. Basically what i need is that when you open ms access database app it will cover all the screen or hide windows start button and taskbar. the reason is that it will be installed on computers where user will use the pc but will not...

Hi Again Can anyone please help me out? i also need to mention here that i need to do it without using outlook. ill appritiate help plz

Hi Guys I have been trying to access gmail through vba in Access 2003. I can send an email from vba using CDO by using gmail account but i cant seem to find a way to read gmails email or download them in a table. i have searched quite a bit online but couldnt find any help. so has anyone done...

ok i have solved the problem although im confused about it. the module is : Function CalcPredFVC(age As Long, ethnic As Long, gender As Long, height As Long) If ([age] >= 20 And [ethnic] = 1 And [gender] = 0) Then CalcPredFVC = -0.1933 + [height] * [height] * 0.00018642 + [age] * 0.00064 +...

i have checked it on the form textbox and yes it works fine. so my question is that why does it gives error when using in function?

Hi Thanks for the reply. well i am using it in a module function and then calling it in query, and it give the error. the reason im doing so is because in query when i try to calculate it by using iif conditions the string becomes too long it it trunc it

Hi everyone i need some help please. i am getting runtime error 6 on the following expression Dim a As String a = -0.1933 + [height] * [height] * 0.00018642 + age * 0.00064 + [age] * [age] * -0.000269 i tried all variable types eg long int, double etc. and the error only occurs if the...

Thanks Addyman Thats has solved the problem.

Hi I am using dcount function in a query. when i use two AND conditions it works fine but when i use 3rd AND it give error sayn character lenght must be uoto 2048 its the dcount im using: DCount("[Category]","[_RawData_All]","[ID]='" & [ID] & "' and [Category]='DOH FastFood'" and...

i do find a question about my issue mentioned above. in my internet explorer lan setting its set to autocofig and a heep web address is entered in the address. i am not expert in this so can someone plz tell me that is this just the address to get proxy settings not the actual proxy settings...

Hi I have vba code to access a website to send sms. this code works fine when the internet explorer has no proxy. but it never works when using internet explorer with proxy. i have tried everything but cant find a solution. the code im using is: Dim objXMLHttp, sResponse Set objXMLHttp =...

Hi I suggest one simple way would be to create temp tables and link forms to those temp tables. and add the records to the data tables when conditions meet. cheers

Hi, you can set the source of the region listbox to the query filtering based on what you select in Item listbox. for example on the click even of Item Listbox set the source of Region listbox to filtering query. if you need help with how to do filtering query then can you tell me what fields...

do you want to display the photos on the form with unbound picture box?

Thanks very much chris. i understand it now. cheers

Hi NigelShaw, Many thanks for the help. Well its not exactly a school project but its a data analysis. and the reason i have this routine and dont fully understand is because its initially developed by someone else and i have to modify it. i understand vba and im not new to it. however the...

Hi Everyone Im new here and this is my first post. i have a vba code that i dont fully understand: Public Function SCodeSelect(ByVal Value As Long) As Boolean Dim bResult As Boolean Dim ScodePattern As Long Dim ExactMatch As Boolean Dim IgnoreSpecial As Boolean Dim UseOR As Boolean 'Does a...

Hi Everyone. I am from Perth, Australia and my work is related to database development, data management and database analysis. I have been working on Access for last few years and i have a good knowledge of Access along with queries and VBA. So i hope that in here i will learn lots from...