Search results

Hi, I wish to update my present working securedDB with structure updated secured DB by using below code. But there is no response/ error when excutes. Even tried by removing password to DB at source. If password exists then error 3031 appearing at OpenDatabase. Any helpful suggestions will be...

VBA Execute, cannot getting data and throwing runtime error 3061 with too few parameters required. Here i am executing an SQL insert statement, getting values from another mainQuery which representation of various join queries(of 6 child queries). where as mainQuery showing the data in...

Hi Guys, Happy new year to all. Today i got an idea to Create,update or delete or insert , alter data from FE(compiled). That we can create a unbound form and making a unbound longtext box and a subform which will show what we run the code in textbox. To run a query a go command also on form...

Me.simg.Picture = Nz(CurrentProject.Path & StudentPhoto, CurrentProject.Path & "\StudentImages\INDEX.JPG") Me.fimg.Picture = Nz(CurrentProject.Path & FatherPhoto, CurrentProject.Path & "\StudentImages\INDEX.JPG") But this code is under forms onCurrent event if there is a no string i got error...

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

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

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

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

Dim dayend, stock, upd As String dayend = "insert into tbl_dayend(dayend,dayenddate) values ('1','" & txtnxtdt & "')" stock = "INSERT INTO Tbl_stonestockopening (stonesubgroup, stonename, size, closinpcs, closingweightcts)" _ & "select stonesubgroup, stonename, size, clspcs, clswt from...

hi, i wish to filter date column where checkbox is false, if checkbox is true the filter should not be happen (or) all dates to be select .

If simultaneously using many users of single database, If all of them working on same form, i needed the unique ID that mixture of date and random ID(which creates randomly different from each user) and data is temporary . after i save them in to database with reference if randomID. But randomID...

Hi friends, I am going to do send messages to mobile numbers of particular columns of a table via VBA . So any of you share the VBA code will help me to opt . for this i have provider and login also. Thank you .

How to import Queries, Forms, reports, classes from accde to accdb??

Dear Developers, I ran in to a virus problem of my all office docs including access files. The problem is all my files and docs has been renamed to filename.filetype.datawait And i dont know why it happened , any solution please help me. thank you

Cant we run a access form on local web browser? that acts as add, delete, update etc..

I am trying to paste the values from form to access browser by clicking the command for auto fill the user id and passwords. So i requesting the vba code .Thank you .

i have compiled my vba code and it does not have any errors and i given trusted location for that file. But it is stopped working while making accde. so what will be the cause ? will any have solution? thank you.

I need message pop up for not matching the value with combo box colomn(0) value. I used below code but not success. Please get me out from here. thank you. Private Sub cboestdet_AfterUpdate() Select Case cboestdet Case Not (Me.cboestdet.Column(0)) MsgBox "Item not found", vbOKCancel...