Search results

Hello, I 'm trying to import a excel spreadsheet which includes a date column and some of those fields show "not attempted" ie Text. When I import them into access, i originally had them going into a text field, but I need to show the ones that are due in 60 days so I need to query using that...

Awesome, took a little but I was able to get it figured out. Thanks again!

Thanks, Can't hardcode, knowing this place they'll require the folder name/location be changed plenty and there are quite a few references to the path in the code. I'll have to figure out this InStrRev thing, I saw something on google just couldn't get it to work.

FilePath = CurrentProject.path I am currently using this path, but I moved my database folder into another folder so people won't mess with it. I still need to create files to the original directory. How can I make the FilePath still relative but up one folder from CurrentProject.path?

Thanks, makes perfect sense.

Dim tempbFlight As String tempFlight = DLookup("Flight", "FlightCCAccesslist", "WindowsID = '" & GetUserName() & "'") DoCmd.OpenForm "maintable", acNormal, "[Flight] = tempFlight", , acFormEdit, acWindowNormal Okay, I tried this. Coming up with no filtering. Stepping through the code...

So I am using the following code to the the userid: Function GetUserName() As String Dim LUserName As String Const lpnLength As Integer = 255 Dim status As Integer Dim lpName ' Assign the buffer size constant to lpUserName. LUserName = Space$(lpnLength + 1) ' Get the...

Okay, I figured it out. When I was creating my report, I was putting the name to the label, but not actually naming the label itself. Once I named every object correctly it worked. :banghead::banghead:

The button code is simply: MakeReport I tried to go line by line, but I continue to get the same error, and I am not sure what I can do to get more information than that. Thank you for trying to help.

Yes, the code is in a module, and a button on the form 'frmChooseFields" calls the function.

Sub MakeReport() On Error GoTo Err_MakeReport 'Open report in design view to write properties to objects DoCmd.OpenReport "rptCustom", acDesign 'Read combo box selections and use subroutine to set report object properties SetReportControls Forms!frmChooseFields.cboField1.Value...

That was my first idea, but I tried and continued to get errors.

I have been using the following tutorial to find as you type. http://allenbrowne.com/AppFindAsUType.html It works great, but I don't like that I have two comboboxes, I just want to search one static field (name). How can I rework this so I only have have one field to search, or even just to...

I've followed this PDF to create reports on the fly. http://www.grbps.com/access4.pdf The process is what i am looking for atleast to start out. Problem is i've done this in my project and tried to do it on its own and I get an error both ways. "Application-defined or object-defined error"...

Perhaps start out with just plotting the points for each city on one map. And then go on from there.

I'm trying to create an automated way of making a way to contact our personnel in case phones cannot be used. I have a list of all the address and currently seperated by cities. I want to step it up a bit and with the use of google maps create a shortest route map. So one representative from one...

I just checked, surprisingly, SP2 is installed!

Am I the only one with this issue? Everytime I need to update something like a combobox with a new list value or maybe the default input I have to do that multiple times since each time I switch between design and layout views the change or update did not take. :banghead: It is frustrating...

I've been using the Allen Browne FindAsUType function with some success. The fuction allows you to filter your tables as you type. What I've been trying to figure out without success is how I can just limit them filtering a certain column of data. Right now they can select name, cell phone, etc...

I am using the following code to get results from next month, Month([ptdate])=Month(Now())+1 which works great to get next months results. I try to get what is left of this month by adding the code: Between Now() And Month([ptdate])=Month(Now())+1 This actually gives me results from...