Search results

Me.txtnums.Value = SimpleCSV("Select smsnumber from Qry_sms_numbers")

After i changed to db.OpenRecordset(strSQL, 1)" the below error i got. actually i had linked tables , from then i created a the query "Qry_sms_numbers".. Is this the correct way?to get data?

hi DBGuy thanks for link. and i copied that and passed a sql string through paramater and i got error 3061, 'too few parameters- Expected 1', then placed at "Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot)"

it called from command button on form. txtnums is a textbox on the same form. when i click it shows error massage as type conversion and debug window highlighted at " ssql = "Select " & fieldName & " from " & tableOrQueryName ".

can you suggest the fair one??

i tried to run this procedure for the column values to convert to row values and separated by ",", i had a code below. But i didn't find the way to execute this <code> Public Function RSFieldAsSeparatedString(ByVal fieldName As String, _ ByVal...

I have a client which doesnt have Office installation and it has only Access runtime. But while opening Warning message will show..Can i disable that one??

BE changes will made by me. and later client DB will be updated. Now manually im doing all the table edits / inserts in client place also. So to overcome manual interaction i need to run a code that all modified DB properties to append the client DB . And BE is a secured with password. client...

and not even compare only, i need to update with new assets to existing DB..

Can we compare a DB with another Modified/Altered DB(Which is updated with more tables/added columns to exists tables)? if yes what code can i use to integrate of exists linked tables and local tables? and may it can be like a tool for deployment for updated Backend file. we just run and...

3-4 subforms per tab i have.

Edit1: The temp tables have not much data but before it has very boost. now takes up to 8-10 seconds edit2: Yes, I really need to requery. Bcz there will be #deleted data will apear in subforms edit3: Yes, it has only 1 record in that table.

Acce Access is my BackEnd And i will try Condition method also..

Record source is null at on open. After opening form with 4 temp Empty subforms which are accessing from same DB. And saving those filled data to another linked DB which is in another drive.. Probably records up to 5-15 for each form while saving . After successful saving report to be opened...

yes, It is split db. here is the code on load event << Private Sub Form_Load() Dim warndate As Date Dim validdate As Date Dim trandate As Date trandate = DLookup("dayenddate", "tbl_dayend", "dayend=true") warndate = DLookup("paymentdate", "tbl_paid", "active=true") validdate =...

As of my knowledge i written bunch of code at on load / on format events ... But its taking much time to calculate and format. What else i can do to run faster??? Thanks in advance for your suggestion.

I have tried to connect Tally ODBC Server to my accdb . There is a Server name but cannot connect to database...??? I dont know what s wrong with tally DB. Error message 7711. Why can't access connect to TALLY ODBC!!!

its perfect.....Thank you

Closing units: [opening units]+[purchase units]+[return units]-[sales units] Here closing units is calculated field on query

Hi, I had a database with some tables . I created a select query from different sub queries (Which are grouped by Product ID and summing of [Units]). I have 5 Subqueries with same properties . all individual query getting data correctly and also main query also showing the data correctly. But...