Search results

Hi Everyone I need some help from experts here. I have an MS Access frontend linked to Sql server backend. There is no relational integrity defined. There is an Auto increment field for AutoID in the table. So the issue is that sometimes some records are getting deleted. and when i look in the...

Hi guys I need your expert suggestion I have a database in which I have VBA code to modify report by changing report source and source of text boxes on the report. I use acdesignview in VBA My understanding is that it will not work in runtime version to modify report. However it does work on...

Hi guys I need some help i have been trying it for so long but failed to resolve it. I have created a small application in Qt for andriod that works fine on desktop. byt when i deploy it to andriod device the connection show its connected but fails to read or write from sqlite database. i have...

Hi everyone I have developed an application that has MS Access frontend linked to sql server backend database. Recently the sql server admin informed me that my frontend application is causing the sql server to suspend few times and he had to restart the server each time. he sent me the log...

Hi I am trying to run query on a large sql server view linked in ms access. the view table has records in millions and I am trying to get data from that view table for around 2300 people. but query always time out/odbc call failed. I am able to run query if I filter for one person. I also...

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 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...

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...

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...

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 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...