Search results

Because you suggested that I should use a different development environment, I decided to look into it. I found Xojo and MySQL. I used SQL Server for a lot of years and with work bench, I have the IDE. I went through the code for xojo and it is very much like vb, so I've set that up. I'm...

Wow, I will definitely try that. Thanks

This code really helps. Didn't know you could do that. Thanks

I really like coding and I'm pretty fast at it.

The listbox is not multiselect. I do have some that our, but this is not.

While writing this program I have discovered some new features. Back a long time ago if you wanted to programmatically select an item in a combo box you had to loop through it. Since I programmed in VB for a lot of years, and already had Access I decided to write this program for myself. I am...

What combo am I copying from? I am setting the value of combo boxes from the table. As far as Access goes, it is good for what it does. I just prefer more flexibility. I retired and Quit programming in 2010. I'm not sure what version of asp.net I was using. I used VBA with vb4- vb6 for a...

People do save information they have entered into a form, and at times they want to view what they have entered into the form. I am not copying to another table, I am filling the form with their saved record. Also, these primary forms do re-occurring scheduling. They can select any day, any...

Thanks I will try that. Looks much easier.

Is there another way to select an item in a listbox? I am filling a form with selected information.

I have finally significantly reduced screen flicker. Pat Harman suggested simplifying the design. I went through all the tables etc. and there was only one combo box that I could remove. What I did to stop the flickering was... Made sure all labels were connected with their related control...

I think you are right. I need to simplify this more. I'm going to work on it.

I tried not painting both the main form and subform, a little better but still flickers

It is complicated. I don't get much flexibility using a bound form. I will usually bind sub forms but not the main form. I can do a lot more things when coding.

I just tried changing the field2... to nz and it made no difference. Public Sub LaunchBillForm(ByVal LBillID As Long) Dim s As String Dim sName As String Dim sFrm As Access.Form Dim rs As DAO.Recordset Dim fPB As Form Dim iPayMethodID As Integer Dim LID As Long, LBankID As Long On Error GoTo...

The last pic I posted is the navigation form with the form inside the subform control. I tried using nz but when dealing with dates and empty strings I get a lot of errors. Only a few fields are required for data entry. I did make this procedure to avoid requeries. It did help some but not...

The main form isn't bound, only the sub form. I made my own navigation form where all forms are hosted. I need to be able to handle the main form in code otherwise I get lots of errors. The field2string, field2long, field2integer, field2single I use to check for null and empty values so that...

There are different transaction types with banks, i.e. deposit, credit, transfer, automatic deposit, payment etc. Also there are different account types for a bank... like savings account, checking, 401k etc. People table and the Bank table are the top tier tables.