Search results

It certainly has records in the table at one point. attached is the screenshot of the form, after refreshing when it shows new records and time in, we just select from the dropdown circled in green an option and it then prints a ticket with time in etc. but when we dont see a records that we...

Ok let me explain. its a readonly continuous form that refreshes every few minutes and fetch data from another server into its own sql server backend table. so we see that after refresh some records appear in this form. but after sometime with another refresh some records are gone. we make note...

no, its a readonly continuous form fteching data from another source

Its because some records are getting deleted randomly and i dont know how are they getting deleted. so when i look at it i can see missing ids thats where records are deleted

There is no button on user form to delete records

Records are saved as they are visible for a while before disappearing

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

In the table these are rows but i have to write alot of code to format them into columns on the report. its because data is enter as usual which is in rows

Yes its accdb and i have not created accde because accde wont run the vba code to modify report. some have suggested here that its a poor design to copy reports but it depends on the situation. let me explain my situation why im doing so these reports are the treatment charts generated based on...

Right, so basically thats what im doing in vba: open report in acdesign change recordsource of report change controlsource of textboxes copy report as new report so you think in runtime version it will run all that vba?

Yes i understand that. but my question is that when i run the database in 2010 runtime version why does the vba code works and modify the reports?

I think there is a very easy, quick and efficient way that i have been using. so basically if you have a web hosting with sql server then convert your access backend to sql server which is very easy and very quick to do. there are many tools available to do that. then upload or import your...

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

Thanks for all your advises. well as I mentioned earlier its a state wide database and there fore roughly I would be search among over 20 million records. well fields are not indexed. I know its a huge problem but this is how its setup. basically these are the views they have created for user to...

Thanks CJ_london and Mint for your reply Its not just a specific query. infect there are multiple queries and they are sql queries and some in vba. Connection to the server is via ODBC The expected return is usually in thousands and sometimes in tens of thousands. Just to explain further...

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

thanks for the replies guys. Firstly the sql server is run by some other ppl and i dont have any user rights to change or create any views or procedures. All i can do is to link and read views data. It seems to me like views dont have indexing. And the reason i want to filter 2300 ppl is because...

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 Thanks for the reply., I followed the link and the info there is for Microsoft Windows 98 or Microsoft Windows NT 4. but i am using windows 8. i did however tried to implement the article but it didnt work, i guess because im runing win8. so is trhat any more suggestions/ideas? Thanks