Search results

Thanks for the quick responses "chaps"! Not sure I understand all of it as I'm a bit of a novice at this. I was kind of hoping that there would be an easy way I could say to Excel, "Right! This is the Access database you are going to be connected to and you'll put the results from its specific...

Hi Accessers! I have an Excel workbook that has 36 sheets which each hold information on teams entering competitions. Data from each sheet is collated on a single sheet, then transferred into Access for sorting by using a series of queries to further sort the information. The sorted data is then...

Hi Accessers! I've created several Split forms that have the data input fields in the form with the relevant query datasheet shown below. As you tab through the form fields, the various cells in the datasheet are highlighted and move across the data row (as one would expect!). I want to put a...

I guess that what comes from not starting from scratch. The basis for the db was information on a 2000 line multi column excel spreadsheet!

Thanks for all the inputs, but it all proved too complex and time consuming, so I introduced an IIF that looked at the various dates and depending on a cell having a date in it, produced a Status. Project_Status:IIF([M2Achieved]>"","Milestone 2 Complete",IIF(M1Achieved]>"","Milestone 1...

Thanks PR2-eugin! I tried that without success. Once I mover the employes Name into the body of the form everything worked as advertised. Just another little thing in the learning process!:)

I've got a bit of a problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. (This is so I can show multiple records for that employee without having their name repeated at each one). I also have the name of contact...

I've got a bit of a further problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. I also have the name of contact [ContactName] that sits in the Detail area of the form. Both names come from their own tables that have...

Not sure if this can be done, but here goes... Having built a database that tracks projects across their lives, I've now been asked it I can identify the latest status of the project in a "quick view" The table "All Projects" has columns that list the Project Number; Project Title; Project...

Hi Alan Slightly different approach on the other site. I was struggling severely with trying to resolve this issue and having introduced the database to the team, realised I had to find a way out of it as soon as possible, so I posted asking for someone to have a go at writing a code for me...

Thanks CJ! I'll try that, but I also had a better think about it and linked the form through a sorted Query which works well. Cracked it two ways!!

I have a "Date Select" form that is linked directly to a table that only has one column in it, "Dates". The column in the table is a Date/Time column and is sorted in date order, Lowest to Highest, and when any new dates are added to the table (through another form) they re-sort into date order...

Thanks for the idea RX but times running out to get the db into use and I've little idea of what I'm doing! I may just shelve this bit until I have more time to try and better understand coding. Shame really as it's the last part of the db. Still, I'm proud of what I have achieved!!!

Not too sure Alan. Sometimes it seems to transfer data to Excel before it throws up the Type Mismatch, other times it doesn't pass the data over before the error comes up.

Thanks Alansidman. My brain is a bit too full with this at the moment! I tried pasting the whole lot into a Module etc but ended up with the database just bringing up repeate error warnings; one without any wording on it. I was hoping there may be something a bit easire as I really am at the...

Still new to VB / VBA and trying to create a code that will export data from a query into Excel. I managed to get that far, but the process ended with a "Type Mismatch" message and the data not always transferring, (it should overwrite the previous export) Looking at the Excel spreadsheet there...

CRACKED IT!!!! Added in the Format bit and it puts the date in the SQL as US. That then transposes to Aussie date in Criteria! Private Sub Command8_Click() 'Set it all up for Meeting selection Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim...

That cracked it Thanks Pat!

That works a treat Thanks lagbolt!

Thanks lagbolt I'll give that a try. A customer folder will exist as it's put on file prior to enterint the data into this tracking database. The issue is that the name of the customer in the Entity cell may differ from that of the folder (could have the Pty or Ltd missing off the folder name)...