Search results

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.

You could create a form with 3 subforms. It would look look like this: Small size form with records before the big one: ---------------------------------------- InvNmb CustName InvAmount ---------------------------------------- The big form with all the fields You could create a...

Thank you Bob. Unfortunately, I already tried all this. All the fields have the same settings, and all look the same in the backend table. I even tried looping all the fields in DAO and setting the values once more, but nothing happened. The reason this is bothering me is when I design a form...

Also one more thing. If I make any change to any field (not just yes/no) directly in the backend in table design view everything starts to work. (I cant do this for each customer individually as there are many customers)

I have a problem in datasheet view of my table. I have 6 checkbox fields in my backend table. If I open the backend database directly and open the table everything is OK. But if I open this same table from my frontend as a linked table, only two fields are displayed as checkboxes and others as...

I mean just call it from VBA and give it the web url to the database ?