Search results

Thank you. Considering that these field can even be left blank (not update), should I also indicate REQUIRED YES?

Hello, I am getting the following error message when closing a form: Run Time Error 3315 – Field XXX cannot contain zero length string. My db is update every month with data that I import from a text file. Data is imported in a table (table1) and displayed in form1 using a query as records...

The big problem I have faced in the years with the split db is having someone on the other hand running the refresh link table manager and other simple routing maintenance tasks.

Hello, I would appreciate any help with some code or advice on how to provide future assistance with my db. Since I have completed the database, periodically it may happen that some office may require an update or change to a query, form, etc. I was thinking of a way (copy object method?) that...

Finally works!!! Thank for your help.

Sorry, my type. I did change the code to false but still getting the same problem. I cannot view any form. By the way, I created a similar macro and converted it to VB. It's the only way works (although not the correct way) DoCmd.Echo False, "" DoCmd.OpenForm "LogIn", acNormal, "", ""...

Hi, the code is in the AfterUpdate Event. The code does run without the Forms!Login.visible = True line. It works also if I put it in the OnChange event (without the hide line). Private Sub cboLogIn_AfterUpdate() DoCmd.Echo False, "" DoCmd.OpenForm "FrmMenu", acNormal, "", "", , acNormal...

Yes, made all the changes as suggest but the login does not hide and the frmMenu does not show up. Strange

Thanks. Got an error while trying to download. Will have to try tomorrow.

Thanks. But would not know how to write such a code.

Sorry forgot to say that the login is a pop up form and the frmMenu has a normal view. Thank you

Private Sub cboLogIn_Change() DoCmd.Echo False, "" DoCmd.OpenForm "FrmMenu", acNormal, "", "", , acNormal DoCmd.Maximize Forms!login.Visible = True End Sub

Hello, I have added your code, but all forms seem to disappear, as if the hide function prevents to view the frmMenu.

Hello, For my db, I have created a form which I use as a kind of login screen that has a combo from which users select their name. Once selected, a command opens the main form. DoCmd.OpenForm "FrmMenu", acNormal, "", "", , acNormal DoCmd.Maximize Since most other forms in the db have a...

Solved. As recommended I wrote the format portion of the code before the export. Working great: Set appExcel = New Excel.Application appExcel.Workbooks.Add Set wksData = appExcel.Workbooks(1).Worksheets(1) wksData.Range("L:L").Select appExcel.Selection.NumberFormat = "@" For intRow_Index = 0...

This is also what is confusing me. Unfortunately my knowledge is quite poor in programming. I think a bit more info will help. Data that I export from my lstbox to excel which is not formatting correctly is text. Examples are: 0123456789 or 12121212CC222, etc,. This meand that although has...

Sorry friends if I am bothering you on this but I am almost near to the solution. I have been lookin at all your suggestions and without having to do much changes I have used Arnel's code and chaged it as follows: appExcel.Cells.Select appExcel.Cells.EntireColumn.AutoFit...

thanks Arnel, sorry a bit confused. This is how I have my code: Next intColumn_Index Next intRow_Index wksData.Range("A:" & Chr(65 + UBound(lstBanks))).Select appExcel.Selection.NumberFormat = "@" MsgBox "Your selection has been exported to Excel. Click OK to open.", vbInformation, "FindMe...

Thanks Arnel, this time I get an error on the UBound. When I add the additional bracket, additional spaces are added. Sorry for not explaining myself correctly. wksData.Range("A:" & Chr(65 + UBound(lstBanks))).Select

Sorry Crystal but cannot open the Bas file due to restrictions on my PC.