Search results

  1. S

    My DB crashed or whats is it ?

    I was finding something onm goole and downloaded few stuff, meanwhile the system started behaving abnormal now the access db 2010 with format accdb is now showing like this abcfile.accdb.mass and even i changed the format and correct it to abcfile.accdb then it not opeing and shwoing the error...
  2. S

    Form Loaded

    Hi, I have a Function below, I am calling this in query and having error when form is not loaded or closed and i want that if form is not loaded then the query to show all records or in simple words should ignore this criteria without any pop up error message Function IsFormLoaded(strForm As...
  3. S

    Message Pop up for Records if not saved

    I have a command button named "Go_Set" in a form named "Payments" i want if the user forget to hit that command button which include an append query and refresh command the at the time of form close there need a pop up message box where if hits "YES" then this yes should hit command button...
  4. S

    Rows Append

    Hellow there!! I have a table with field name Sdate (Short date dd-mm-yyyy) In the same table i have another field I_Months (Numeric field) now what i want that if i select todays date i.e. 12 Dec 2019 and select 6 in I_Months field means i want 6 rows to added in new table with month name...
  5. S

    Finger Print Scanner with Access

    I have a DB in MSAC 2010 I am looking to have a finger print device attached with DB to store name
  6. S

    Hiding Form views

    Hi, I like to hide form change views option please refer to the attached pic
  7. S

    Online facility

    Hi, Is there any way or option to use access 2010 online on internet ?
  8. S

    Moving Text in Textbox

    Hi, Though it is difficult to explain but in short i want a text box and wish to see the context/text written in the box be moved from right to left automatically through vba no problem if is done with label...
  9. S

    Date format in Urdu font

    I have a date field like format([cdate],"mmmm-yyyy") i want this field to be translated in urdu font ... any idea ..
  10. S

    Dlookup with Date Criteria

    I am having a field in query "Build" named as "Month" which is a format of Format([vdate],"mmmm-yyyy") vdate a short date field I want to dlookup field name "Total" in the same query build from another query have same field of month in this query which is Format([cdate],"mmmm-yyyy") cdate a...
  11. S

    Form Fields copy

    Hi I am having a command button named "Start" now what i want that when i click this button then it to copy all fields data in that particular form and to be pasted in same form as new record. Suppose form name is "Lounge"
  12. S

    Debit credit and balance in Query

    Hi, I am using below formula for another DB and working fine and showing current balance, now in another DB i have different scenario like A_Bal: Val(DSum("nz([debit],0)-nz([credit],0)","vdebts","vids =" & [vids])) Vids is a vendor ID numeric Tr is transaction ID in same table as numeric...
  13. S

    Access Accdb 2010 slow on Ethernet

    i have shared a DB in 2010 through LAN but still at the second pc where it is working as shared opening slow and working slow... rest it is working fine at main pc where it is present. Both PC having Win 7 64 Bit with Office 2010 Suit 32 bit
  14. S

    Class error 430

    hi using this on a form on load event it poping error class does not support ... interface.. else on another pc with same os is running fine with no error.. the code is below Option Compare Database Public Function LogIN() Dim TempID As String Dim TempID2 As Long TempID = UserOnName TempID2...
  15. S

    Shared PC VBA issues

    Hi, I am having a DB at my PC in drive D, iam using it fine, else the user is also using it fine but a form is associated with VBA and that is not runnging from user pc, i have shared db in shared folder and connectiion is through ethernet cable.
  16. S

    VBA to add dlookup

    //sendpk.com/api/sms.php?username=xxxx&password=xxx&sender=BrandName&mobile=xxx&message=TestSMS[/url] here above is the link i am sending sms... now i have a form named "Send_SMS" with two text boxes one is named "Number" where i am entering number (text field), second named as "Message"...
  17. S

    Web Page Opening

    Hi I am trying to execute http web page through access 2010 form without opening web page... say its a text message to parents when paying fee .. so there is no need to open web page... i will do it through command button
  18. S

    GSM Modem

    Hi, Looking as simple as you can understand... I am looking to get VBA Code attach a nokia c1-02 cell phone with my SMS packages and now i want to connect this phone with my access 2010 DB where i have a form named "TR" having these fields, MobNo: to insert mobile number Txt: to insert sms...
  19. S

    SMS via Bluetooth

    Hi, What i am googling around that i have developed an access 2010 DB for school, what i want in an fee payment form that when the user hit command button to save then it also shall send sms to the particular moble number being predefined in th DB at form. The est option for me is to connect...
  20. S

    Export to excel xlsx

    Regards, I need VBA for a command button at report to export all data from table "todaydata" in access 2010 db to be exported in excel xlsx file at desktop with name "book1" the path of file is below C:\Users\yousuf traders\Desktop
Top Bottom