Search results

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 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...

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...

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

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...

Hey This may sound very odd but when i run a where statement in a RecordSource, >= works fine it includes the number, but when i run <= or = it wont :S ahahah sounds dumb but its got me stumped... Cheers Tim

Hey All, Im trying to change the field selection in a query that im exporting by breaking up the SQL statement but am having some difficulty: qryTest.SQL = "SELECT" & varselect & "FROM qrySummary " & BuildFilter And is there a way to carry a string over from one form to another? The...

Heya Hit a snag, im using a RecordSource to add a variant with a filter to a form from another form the odd thing is it sometimes works and then sometimes decideds not to.... [Code] Me.frmSummary1.Form.RecordSource = "SELECT * FROM qrySummary " & BuildFilter...

Hey all, Cheers for all the help so far, im trying to open a subform in a new window and apply variant that ive built up as a filter to the subform but logically it hits the variant and goes to build it up but as its now a mainform the unbound text boxes arent there... Is there a way of...

Hi All, What i have is a datasheet sitting on a form1 and button1 connecting form1 to form2... On form2 i have radio buttons allowing the user to hide and show columns... the user then hits button2 which runs DoCmd.OutputTo acOutputForm, "frmsummary", acFormatXLS, "TblExport.xls", True...

Hey All I have a data sheet as a subform and have been asked to export the data back out... is it possible to export data back into excel? if so can the data being exported be: 1) only whats been filtered 2) have the ability to select what fields will be exported Cheers Tim

Hi I have 2 subforms and 2 filters connected by one search button... Is it possible to have when one filter returns a result the second subform uses a date column from the original subform and then filters itself using that? that way if i only have a small section of data i can find as much...

Hey all trying to set up an error handler that raises an error if anything but a number is input into a text box it raises an error... Ive already got my error handler set up and working beautifully its just this im struggling with If IsNumeric(Me.txtMin.value) = False Then...

Hey All, Just need a little help with some FSO stuff... Im trying to import some data from some files into a folder but it either doesnt copy the data or i just a rubbish result file... Sub filefinder() Dim fs As New FileSystemObject Dim f As File Dim fld As Folder Dim LastRow1 As Integer...

Hi all! My last little bug and no more annyoing help me messages!! :D!!! Is is possible to have someone input data into a text box and then in a subroutine grab it rearrange it and put it back together? what i want it to do is: DD/MM/YYYY - split it into DD, /, MM and /YYYY then swap the 1st...

Hey All Sick of hitting my head against a wall on this one... i put in the Buildfilter = varWhere On Error GoTo Panicstations Panicstations: MsgBox "Invalid Input - Clearing Form" btnClear_Click Err.Clear End Function and i cant get it to run through without constantly...

Hey quick question, I have a date column and have the following code which works perfectly but i can imagine a user asking just to simply search a year rather than a full date ' Check for min date If Me.txtdatemin > "" Then varWhere = varWhere & "[DateRun] >= #"& Me.txtdatemin...

Hey all, Almost there :D!!! Im having trouble setting multiple option buttons to one text box: heres a simplified version of my code so far, but it all has the same subroutines and all that stuff.... whats happening is its not filtering... not sure what to do.... Private Sub btnSearch_Click()...