Search results

No, it's a normal Access table. it seems as @jungli and @arnelgp suggested, creating a new column instead and moving the data to it instead to modify it. Thanks for the advice.

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

I don't think this is the case I open the form first by using the docmd.openform command then I referring the forms collection, This is from the calling form: DoCmd.OpenForm "frmVendorInvoicesSelector" Forms("frmVendorInvoicesSelector").TransmittalID = Me.BatchID...

it's the same form class module, and I am defining new property using the Property Keyword to configure the form. but the value I assign to the form (stored in module-level variables) just disappears when using the split type form.

if you are interested I can prepare a compact example showing the case

I am using it for troubleshooting, In my case, I added some attributes (module variable/Property) to the targeted split form for configuring it, but after configuring the form and when accessing the attributes (properties get/let) from inside using the Me variable, the values I assigned to those...

Thanks @arnelgp I just figure it out, it's the split form, they said it's cursed but I didn't listen (really don't use the split form, use a subform instead). I just change the type of the form to a single form and it worked normally and all the object references were right. for the ObjPtr...

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

I think the issue with the name of the function in the subform Public Sub FCRate_AfterUpdate() it shouldn't have an underscore in it you can make it like "UpdateExchangeRate()": (Parent Form) Private Sub FCRate_AfterUpdate() If (Forms!frmJournalHeader![sfrmVoucher Subform].Form.FCRate <>...

what is the line that gives you the error?

You can write a function in the subform to update all the related records as follows: Sub UpdateExchangeRate(Rate As Currency) Me.Recordset.MoveFirst Do While Not Me.Recordset.EOF FCRate = Rate Me.Recordset.MoveNext Loop End Sub then call it from the parent form...

Indeed modern versions of windows almost you can't write outside your user file without administrative privileges, so try to use your user folder. you can run access as administrator but this is not recommended.

I think it's normal to get 0 because the first dimension of the array contains the fields of the recordset and in his query only one field retrieved the subscript is 0 (zero-based), if there are two fields the Ubound will return 1.

As The_Doc_Man Said you should use Ubound(HLforInvoice,2) Your SQL "SELECT HorseID FROM tbHorse WHERE Mark=-1;" will return an array a(0, n) 0 because there is one field in the recordset n is the number row in the recordset.

It worked With ADO. 👍 It seems the DAO Parsing issue.

didn't work

I tried it with the same syntax error message.

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

Thanks for your input, it was helpful.

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