Recent content by exebat

Hi all, I am currently using AntView ActiveX WebView2 control as my preferred browser control and it works just fine but it has a problem with proper sizing on a form (Vertical and Horizontal Anchor don't work) I am trying to use the new Edge ModernBrowser control but I don't see a way to...

The backup form is couple of months old. If I just use it as it was it works, but if I copy/paste it and try to make any modifications to it, it stops working for no reason. I lost 5 days trying to solve this and I ended with Me.Recordset.Requery in Form_AfterUpdate event. It forces...

I just tried importing everything in new empty database and the problem still persists

Yes and thats why I created a new one with just 3 fields and it performs the same :(

Hi all, A have a strange problem from couple of days ago. I have a main form and subform (Continuous Form) that has a Textbox in Form footer that Sums one of the fields on the form (Total field = QTY x Price). It stopped working just like that. I also have an older backup of the same subform...

@boblarson - Since you used it more than I did, are you aware of any new features for the normal, desktop development ?

I think this is the worst Access version yet. I spent 20 minutes on it, and couldn't find any and I really mean any new thing except the metro interface. Even the VBA IDE is still the same (10 years old) no new addin creating ability, no OData, no better SQL server support, no gradient...

Is there any way I can automate starting Access, opening BE database, opening table in design view, saving it, and closing Access ? Or does anyone have any other solution. Is there a way of going field by field, getting the properties and creating it in the new table, transferring all data and...

Yes, even deleted and linked table again and all the same. If I just open the table in the backend in the design view and just press the save button without even making any changes it works in the FE also.

When I look at table design in the backend it looks just as your first picture and looks ok in the datasheet view. But, if I open the same table as linked table in my FE, it looks like your third picture. And no matter what I do, it stays like that for those 6 fields and any new field I create.

Here are again and the second one

This is how it looks like. In linked table: The same table in backend:

If its privacy you are worried about, just create a new database and import only the form and the table you are having the problem with. And also leave only few records.

If its privacy you are worried about, just create a new database and import only the form and the table you are having the problem with. And also leave only few records.

Using pbaldy solution is much cleaner. Also if it is a multiuser database (lets say invoice), you should execute If Me.Dirty Then Me.Dirty = False as soon as the invoice number gets populated so if some other uses uses the same form it doesnt get the same InvoiceID.