Recent content by brillig12

My apologies. Upon checking I can see that there are three fields directly below the three combo boxes. When a selection is made in any of the combo boxs then the are all cleared and the three fields below are populated. I was convinced that the combo boxes were populated but it is not the case...

My apologies. Upon invesitgating to describe further how the date was wrong I realised that the problem occurs only when the full date is not add. I am used to working with systems that auto correct the date from dd/mm/yy to dd/mm/yyyy, which is the required format for this database. When...

The SQL is as below: SELECT PersonalDetails.SalaryNumber, PersonalDetails.Forenames, PersonalDetails.Surname FROM PersonalDetails ORDER BY PersonalDetails.Forenames; Am new to SQL so am glad of any light you can shed on this :)

Thanks for the tip. I could not get it to work however. I clicked on the (...) and added the sort feature to the SQL but all three list remain sorted by the order of the table. Is there something else I needed to have done?

Hi, I am using a form which brings up data on staff once they have been selected in one of three combo boxes. These are salary number, first name and surname. Once a selection has been made then the other two boxes are autopopulated and the data is sourced from the tables. This is all working...

Hi all, I am using a database which displays data from a table on a grid. There is a button which runs a piece of vba to add a new row onto the grid, which is working normally. There is then another button which runs another piece of vba (please see below) which then inserts this data into the...

It works! :D Fantastic! :) Thanks for all the help.

Have got a copy of the utility and will be testing it tomorrow. Thank you for all your help with this. Has been great! :D Will post again after test.

I appreciate any help you can offer :), as once we can get to the actual code then I can start the main task of trying to fix some of the problems with it. :confused:

Not without breaking some fairly sizable company rules. Is there anything in particular you wanted to try, I am more than happy to follow instructions?

I am only able to get to the main database screens, where I have only six menus (File, Edit, Insert, Records, Window, Help) none of which have an a view code option. Does that make this more difficult to do?

I am possibly be a alittle slow but the MDB database I want to try to access does not show in the project explorer in the vba window. Give that I am unable to gain access to the design mode of the MDB file in question I have another database open which I used to open the VBA editor. Are...

I have a few ideas about what the VBA password may be, which gives me at least a little hope. I can't however find (basic problem as this may be) anywhere to input a password to gain access to the VBA. I appreciate all of your help so far and I am wondering if there is a way to get straight to a...

Thanks for that. Just found an MDB version in a back-up file. Tried to import the module but got a message "Microsfot helps protect this Visual Basic for Application Project with a password. You must supply the password in the Visual Basic Editor before you can perform this operation." I have...

Hi, I work with Double2 and am also trying to get past the issues we are facing. Apart from the tables nothing can else can be imported from the original MDE database. There are only two forms and one module listed but they are all greyed out. Are there any ways to get access to these items?