Search results

Hi guys, I am trying to create an in-memory ADO recordset and bind it to a form, while I am able to create and bind the recordset to the form, the textbox will not bind with the recordset field. Is this possible at all or I am doing something wrong? Dim cn As ADODB.Connection Dim rs As...

Hi Guys, I hope you are having a nice day, I am looking for advice, and what better place to look for advice than the AccessWorld great community. I like to hear your suggestions on a book about cryptography, practical cryptography. a book covering day-to-day use cases in the IT domain with...

Hi guys, Do you have an idea why my backend has those .mdb files? The app is a multi-user two tears (Front and back) application and shared using windows remote services (both FE BE on the same device) BE and FE are created by Access 365, using Access Runtime for production on a windows server.

Hi Guys, I am trying to remove the required property from a field using SQL, but can't find anything on MS Docs, another site suggests using the ALTER Column but I can't seem to make it work. I tried: ALTER TABLE tblVendorsInvoicesOracle ALTER COLUMN strPONo TEXT(20) Null Required Still True...

Hi guys I have a problem and can't find a solution to it please if you could help. I have a form that I use as a selector for records, I instantiate the form using the docmd.openform "frmVendorInvoicesSelector" command and referring it by using forms collection...

Hi guys, I am trying to edit the default value of a text field through the SQL ALTER command but just getting this syntax error. the command: Sub ChangeDefaultForPostedByInTransmittal(db As DAO.Database) Dim SQL As String SQL = "ALTER TABLE tblTransmittal ALTER COLUMN strPostedBy...

Hi guys, I came across strange use of the AND Operator and I couldn't explain it if someone could shed some light on it. I found this example in the Access VBA MS Docs. In the example, they use the AND to compare integers and it's not what you think (-1, 0) Private Sub...

Hi Guys, I am not talking about the windows installer and click to run method of installing, I already installed both Office 365 and Access Runtime Environment my question is, is it possible to run the full version of Access while the Runtime is still Installed (because it's given me this...

Hi Guys, I don't what I am missing I always assign a recordset to a form but now I am getting this error what I am missing. The form is an unbound one.

Hi Guys, I am trying to change a field type using the DoCmd.RunSQL I succeed with other types but I can't change to tinyint datatype (error message attached) DoCmd.RunSQL "ALTER TABLE tblNotification ALTER COLUMN NotificationDate tinyint;"

Hi guys, I am looking for a way to compare two databases tables, queries (fields names and properties) programmatically the scenarios as follows: I have an access application in production I developed a while ago, and for my last modifications I outsource the development to a freelancer, but...

First, I found the Debates forum the only one for this topic. My company's CEO asked me to upload the vendors' logo to their profile in our ERP system (my job title is a software developer), and it's the job of the purchasing department as far as I know. I don't have the resources or any...

I am trying to instantiate a folder object to list the files inside a specified folder through GetFolder Menod of "Scripting.FileSystemObject" object, and it's returning a string instead of a Folder object! Attached: 1. a screenshot of the code and its debugging output. 2. a screenshot of the...

Hi to you all, declaimer I am new to programming and measure my self as going from beginner trying to enter intermediate so bear with me. in those days i working on an access application for my company for data entry, and i am in struggle to fine the right design pattern for OOP...

hi guys I have weird behavior when i am tring to assign value from textbox to another textbox default value, the example will make it clear. Environment: windows 10 office 365 access VBA ' this is not working Me.Txt_Vendor_Name.DefaultValue = """ & Me.Txt_DefaultVendorName & """ ' this...

hi guys I am trying to replay on my thread but i am getting an error message showed in the attachment. i tried sing-out and sing-in and deleted the cookies and change the browser with same result. any ideas..

Hi guys I need your direction for this issue I am working in way to connect access Database to MS Dynamic Nav 2018 (to overcome some limitation), after research I couldn't find a connector for MS access to Nav 2018 (Excel has one but not access), so i think why not to connect directly to the SQL...

Hi to you all my name is hisham, and i am syrian national, residint and working in saudi arabia, I'm working as office manager/coordinator for a construction compay, for some while i'm tring to learn programming from MITx courses mostly for automation and data managment, but now i want to...