Search results

Hello Folks. Does anyone know how to change the orientation of a report? I would like to have the field names on the left side from top to bottom with my summary data to the right of the field names - instead of accross the top from left to right with the data beneath. Thanks so much!

Hello folks, Can someone help me adapt this macro/module (that imports fixed width files into excel) for use in Access? I have pulled in the excel library, but do not know where to go from here. Point of interest: data is not in a .txt file and the header row starts in row 3. Thanks so much...

I would like to use a TransferSpreasheet (import) macro but I do not see a way to allow me to choose what file name to import from. Can someone give me some instruction? Thanks a million!

I have created a function (Module)called mID, I would like to have the value returned in a query. When I use the expression builder and just choose this funciton it says I have the wrong number of arguemnts. mID is: Public Function mID() As String If Not IsNull(DLookup("Customer #"...

How can I use NZ with a checkbox where I am doing a query by form? I have my checkbox set to triple state, but I do not know how to have it return all values if is greyed... Is there anyway of setting this in the Nz function so that it will be true, false or could be either? I have...

How can I write an if elseif statement with the expression builder for a query?