Recent content by Guirg

Hey All, Thanks for the help I've just done it by using queries as Galaxiom has suggested. The amount of VBA and Access ill make it look the same. I think i was trying to get too complicated yesterday. Cheers again

Hey All, I have a form that allows a user to input data directly into the original table. The original data was all in excel documents, and all the sheets have been imported. I have just recently been told that the data in a specific field B was originally based off a sheet (that i have...

Hey now im somewhat hoplessly confused.... I have a textbox and going to expression builder and i keep getting im missing something somewhere.... heres what im using: =DSUM("[Hours]","frm1",varWhere2) where varWhere2 is a public variable that i use to filter the form so it already has...

Hey All, Been searching around and have found a way to have a running sum in an form found here somewhere: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q210338&ID=KB;EN-US;Q210338 is it possible to do this but only after its been filtered? My data is a whole bunch of dates and...

im not the best with vba but what i cant figure out i generally google and find and expand to do what i need... range but the range wont be continuous so a dates are essentially random if u look just at them... is there any way to extract the data in a column into a string???

Hey all, I have 2 unrelated forms sitting on a form one above the other. I then have a range of search options on to search each form independantly. They share a common date field but theres no relationshi[ established between them... What im trying to do it make it so when form1 is searched...

its already set to shared....hmmmm

it already is on a server but when i open it on my comp and my supervisor opens it on his it denies use to one of us saying that its currenly in use...

Hey all, Now that ive got everything working properly is itpossible to have multiple users having the database open at a single time?? cheers tim

Hmm that'll work, its not really a big difference beacuse theres only 5 or so colummns that need formatting but they can be in almost any position hence the search through the columns... any suggestions for the titles with spaces?

This seems to be working but i cant get it to convert columns that have spaces in the headings so ie Cumulative H.... wont work.... :( For i = 1 To 40 If xlApp.Cells(1, i).Value Like "H*" Then xlApp.Columns(i).Select xlApp.Selection.numberformat = "[$-F400]h:mm:ss AM/PM" xlApp.Cells(1...

Hey thanks for that i tried implementing it but its popped up with an error, ill have to disable the error handler to see what it was tho...

Hey All, Small bug that keeps popping up im trying to locate Cells with some title and select the whole column and reformat it: heres what i have so far For i = 1 To 40 If xlApp.Application.Cells(1, i).Value Like "H" Then xlApp.Application.Columns("i:i").Select...

Hey All, Im exporting a query into excel but im looing some of the formatting for some columns. Is there a way of searching a specific row(i.e the headings) for a matching cell and then select the entire column so i can format it properly? Cheers Tim

Hey All Is there a way of changing the format of the data being exported from access to excel?? Within access its being displayed properly as a time and when it goes into excel it changes the layout to date, or a date to a number... if i then manually format in excel it goes back to the format...