Search results

I want to re link all my tables from other database which location is same folder. If a user open db1.mdb it automatically re link all tables from db1_be.mdb every time. If not exist db1_be.mdb in current folder it'll show a message. folder name : test test --db1.mdb --db1_be.mbd Please it...

My table structure is id photoPath name 1 C:\a.jpg A 2 C:\b.jpg B How to show all image per row at report details section in a report like ID Image Name 1 Here Image of A A 2 Here Image of B B Please help me.

In my access database file i have uncheck all of my startup options,uncheck special sortcut, off bypass shift key, protection password of vba code. But my question is,, yet too any body can import all of my form other mdb file. How can restrict my back end to import other file. Any good...

I have a unbound combobox in my form. I wanna populate list value in my combobox. first value is current year. Every time populate 6 values. like as 2014-2015 2015-2016 2016-2017 2017-2018 2018-2019 2019-2020 How can do it? please help

I have two table. TblA(date,income,amountIncome) TblB(date,cost,amountCost) I have made two query for 2 tables sum of amount field.then I have make final query for balance amount Date,SumOfamountIncome,SumOfamountCost,balance My question is when any one table has not record the query doesn't...

My code is Private Sub Form_AfterUpdate() Dim SQL As String CurrentDb.Execute ("INSERT INTO Receive(ToAc,TransactionNo,AmountReceive) VALUES(" & Me.BkashAccount & "," & Me.BkashAccount & ",'00')") CurrentDb.Execute ("INSERT INTO Send(From,TransactionNo,AmountSend) VALUES(" & Me.BkashAccount &...

my code is Private Sub Command12_Click() Dim SQL As String If Me.From = DLookup("BkashAccount", "Accounts", "[BkashAccount]=""" & Me.From & """") Then CurrentDb.Execute ("UPDATE Accounts " & _ "SET Accounts.AcBalance = ''" & Me.ToBal & " + " & Me.AmountTransfer & "''" &...

I have a query with date, name, amount field . I wanna show the amount total by selecting month name from a combo box. How can do it? Please help me...

I have access database (access 2003). i wanna make it for specific computer, it won't be run another computer that's why i have tried with retrieve cpu id,,, at form startup. But i have failed because processor id isn't unique then i have tried with hard disk drive (c) id which isn't unique...

In my database i wanna use the DoCmd.CopyObject command with a button like as DoCmd.CopyObject "Destination path can be browse and select file", "AcInformation", acTable, "AcInformation" Image of the plane: Please how can do this? help me

How can copy table from another mdb file in current opened mbd file? If copy table is exist in current file table will be replaced. Please anyone help me.

I have a form here with a button i wanna when user will click on button another access file will open. or current file will close and another file will open. Is it possible with vb for access? please help me

How to change the default message of Exist table. the message shows like as. I wanna change this. How can i will do this?

I have a main.mdb and backup.mdb in same directory. In main.mdb has a account table. I wanna copy account table to backup.mdb file with click event I have use the function to retrieve the current db path. but it doesn't retrieve the currentdbpath with backup.mdb file. Public Function...

I have a form. I wanna show in a text box HDD(hard disk drive) manufacturer serial number not driver serial number which changes every time when hard drive format. I wanna show the hdd manufacturer serial number which is unique for every hdd. It will not change when drive format. Please any...

I have a database (name: main.mdb) here two tables. account and member. For backup restoring process i created another access (version:2003) file in backup folder which name DataBackupRestore.mdb I have tried to make copy tables macros but here i have a problem for destination. I wanna set...

I wanna make a continuous form with edit and delete button. Normally when user open this form it's read only mode. User can edit or delete current record with click on button. when user click edit button then another button "save" will appear. after editing the current record user have to click...

I have a form and a text box. I wanna when open this form in the text box my pc processor id will show. I know i have to use form load event but i have not skill in vb. Please help me.

I have i field in my table "Id" here i have inputed 16 digit number always. Can i print out every digit with different text box or label in my report? If is it possible by program please tell me how to? It will be very helpful for me.......

I have a report base on my table. Here a check box. I wanna show two label text hide/show base on when check is true or false. It will be when report will be open. I have try this but nothing is happened. Please any body help me If AffecteAc= True Then affected.Visible = True general.Visible...