Search results

I'm pretty sure this isn't possible... I'm trying to replicate the manual excel process we have through the power of Access... I need to be able to sub-total at a project level So that when I run a query for a client say ABC I want to have all the invoices for Project 1 sub-totalled, then...

Hi everyone, I have a subform in datasheet form three columns; Project Name, % Complete and Amount Invoiced Project Name is locked and disabled as this shouldn't be edited... I would like to show in datasheet view that this column is different to the other two to make it stand out... Any...

I found detect and repair in control panel for Office and ran that and it works again... No idea what i did there... Thanks for your suggestions!!

Hi greebo, No it's not split just all in one place... not clever enough to work out why and how anyone would split one anyway... I'm working around this with previous suggestions which clear down my tables, then close and compact and then I manually reopen and import fresh data... Not ideal...

Ok... If i click an excel file icon on my desktop it tries to open the file and gives me a series of errors - it breaks the file path into chunks and tries to open them all seperately... Please see attached doc with the errors I got from trying to open one file... So this isn't a file...

That's the same one I found and pasted the code for earlier... I get the error message: "Could not use 'Z:\Project Metrics\Project Metrics -test.mdb'; file already in use" The 1st time it runs I click ok, it then tries again and it works but before I use it I need to work out why it doesn't...

Hi editolis, Thanks again - that idea didn't work and I can't make any sense of that complex code I've pasted...

I've followed editolis suggestion and have the following code: Private Sub cmdImport1_Click() Dim msg As String, button As Variant, title As String, response As Variant msg = "Is the updated file 'Task Import.xls' placed in 'Z:\PM Metrics\Task Import.xls'?" button = vbYesNo + vbDefaultButton2...

Thanks for that editolis - it got me thinking... whether we could get the database to restart after compacting automatically... I found this code elsewhere... '----------------------------------------------------------------------------- ' Utilities from...

Thanks Dennisk I realise that about the numbers but as the data is literally replacing the existing data it is appropriate (I think) to reset the numbering otherwise doing this on a weekly basis for 20,000 records will quickly mean the autonumbers get silly. Is there a way of automating the...

Ok... I've found literally hundreds of posts both on this forum and on others but none appear to give me pointers for what I want to be able to do... I have three Excel files Task Import.xls Data Import.xls Project Import.xls I have also three Access tables tblTask tblData tblProject The...

Ok... I have two queries both of which take data from two sources and through some convoluted relationships display all tasks regardless of whether they have time booked to them or not - the first one works but doesn't use the right data for my new requirements the second one only displays...

Genius!! :D

Hi, I have a listbox: SELECT ID, [Project Name], [Client Name], [Project Estimated Hrs], [Project Value (Project)] AS [Project Value] FROM tblProject WHERE [Project Status]='Open' ORDER BY [Project Name]; My Query pulls out the detail for the chosen project to feed an Excel spreadsheet...

Thank you David so much - sorry to have called on you so much in the last few weeks but you have been a life saver! :D

Sorry... bit new to VBA... Are you able to point in the right direction? If I type me.cboStaff. it only gives me recordset and not recordsource as an option... Told you I'm a bit new... :confused:

It worked! I don't know why but it worked! Thanks for your help! :)

Originally my hours fields are all general numbers and should be limited to 2 decimal places but all this seems to go out of the window when i start calculating them... :(

Hi,, Hi, I have a form with a list of staff in a combobox cboStaff which displays a list of staff based on a query "qryStaff" SELECT tblStaff.ID, tblStaff.[User Name] FROM tblStaff WHERE (((tblStaff.Enabled)="enabled")) GROUP BY tblStaff.ID, tblStaff.[User Name]; I want to now add a checkbox...

Ok... I have the following query: SELECT qryDataWeeklyHours.[User Name], qryDataWeeklyHours.[Timesheet Period], qryDataWeeklyHours.[Weekly Hours], qryDataWeeklyHours.[Discretionary Hours], IIf([discretionary hours]>=0,[discretionary hours],"0") AS [New Discretionary Hours] FROM...