Search results

If all frontend db's and the backend are closed and the .laccdb file is still present, just delete it.

Answer to... part one: nothing part two: no.

Unfortunately not. - But the main thing is, it's ok now.

Hi, the OpenDatabase method has the following syntax: Expression.OpenDatabase(Name, Options, ReadOnly, Connect) On your machine with Office 2003 you have to use 'Excel 8.0' instead of 'Excel 12.0 Xml' for the Connect parameter. Good luck!

We have something in common, taking classes "it's information overload" as you said in a previous posting. However, the "best way to learn programming" depends on your personality. Younger people search (and find!) nearly everything in the internet. Older people (like me) are used to search in...

Hi Rita, don't exaggerate... In case this thread is coming to an end, let me add some thoughts. In the meantime I had a look to some "other corners" of your big application. In summary I would say you made the same "mistake" I did years ago. I started developing without any knowledge and then...

Sorry, there was something I've overlooked. See, if it works now (including form 'Products'). I set the property 'Allow append' in 'sfComponentParts' to 'No'. Because of the relation between the tables 'ComponentParts' and 'CompontPartsActual' it's not possible to add new parts in this subform...

Precisely! As I'm not familiar with MySQL, I cannot advise but it shouldn't be that different. Good luck with your project!

You sound quite desperate. Don't worry, I will support you until you succeed. The message "formulare!fkits!qKits" which popped up was my fault. I apologise! I've added 'qCompPartsForSubform'. Why? For two reasons. 1. It did not work the way it should (that is to show the parts right after...

If this is a real enterprise application of course they should not be able to see the code. I would do it like this: - When the user starts the frontend, run a check to find out the backend version. - If it's not the actual one, run some code that executes the 'alter commands'. - If...

You can run 'sql alter commands' from any frontend. I prefer to do it using ADO commands. I suggest to implement a second 'backup feature' for your 'offline version'. See also: http://msdn.microsoft.com/en-us/library/ff196148.aspx

Did you try to create a new table (manually, not by copying the structure), fill it with your records and delete the 'corrupted' one? Did you open your database with the /decompile attribute and then compact/repair?

Create two DAO recordsets, move through the first one via loop, use the 'FindFirst' method upon the second and set the field values of the second recordset accordingly if the values of 'A_Code' match.

Maybe you should put it this way: Debug.Print Eval(" & [myTable]![myField] & ")

You're welcome.

Hi Big Pat, what's the best way to proceed with this? I don't know. But I found a solution using VBA that works at least: Private Sub AppendExcelData() On Error GoTo Err_Append Dim dbXLS As DAO.Database Set dbXLS = OpenDatabase("PathAndNameOfYourExcelFile", False, True, "Excel 12.0...

Hi plog, I hope you don't mind for jumping in. PMF1957: in Access normally you can open a form only once. To go to another serial number you can put an unbound combobox on your form, let's name it 'cboSerialNumber'. Set the record source property to: SELECT Equipment.EquipmentID...

Hi Salbrox, the code you 'found online' cannot work. If you would replace the line If Left(9, ThisLine) = "<STATUS>" And Right(1, ThisLine) <> ">" Then by If Left(ThisLine, 9) = Chr(9) & "<STATUS>" And Right(ThisLine, 1) <> ">" Then then it would work, that is: without error, but it would...

Hi brucey54, nightmare? Driving mad? - Let me put you out of your misery. Lookup fields are a very practical thing... but not convenient in your case. For a few hours I did like as it would be my database. See the result in the file attached. It would take several pages to explain all my...

Hello Rita, what I've found: - routine 'KitsCompleted_BeforeUpdate' was in the module twice (if you get an VBA error telling you somewhat like 'ambiguous expression', then you should search your modules for double procedures). - when 'fKits' opens, the field value 'InventoryTransactions.Date'...