Search results

All, Attempting something I have not tried before. Have the form shown. Need to accomplish the following on the subform: Change color, row by row, for different status values, Change value, row by row, from either drop-down or pop-up. I actually only need to change/manage color and value...

All, I posted my thread about the DB locking up: http://www.access-programmers.co.uk/forums/showthread.php?t=180381 This has now left me with a hanging open session in the BE file, which says it is my DEV machine, but soft and hard reboots have not cleared it. I need to run weekly...

All, I have a FE/BE design in production. Last week the FE blew up on one of MS, memory collision errors. Since then all my forms on the FE are coming up in either POPup or Modal mode. It is causing all the users to hang and not be able to run the processing. I was able to clear this...

All, I have DB designed with FE & BE and need a script to force users off the BE for maintainance with "Compact & Repair" as default maint. I know there is a script out there, but forgot the URL. URLs please!! Thanks! OMR

All, Does anyone have a link to a good example of how to call a printer in VBA? Thanks! OMR

All, I'm trying to run an export from Access to Excel, but the transferdatabase method does not work well with the query I have: WHRstr = "WHERE ([tim_wdt] >= #" & FMTval & "#) ORDER By [tim_wdt] desc;" SQLstr = "SELECT * FROM qryMARTIN " & WHRstrSeems all the method is capable of is a...

All, Have a frustrating report problem. Have code of:Function RAmount() HrsAmt = DLookup("trp_ham", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) MilAmt = DLookup("trp_mam", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) RAmount = HrsAmt + MilAmt End Function Function RCount() RCount =...

All, Having a problem with process flow while printing. I have a process that: Pulls and Prints a summary sheet grouped by client (report 1), Pulls and Prints a seperator page with Client Name (report 2), Pulls and Prints the Client tickets for the Client (report 3) Problem is each is...

All, All the help & HOWTOs say you can get subtotal from groupings and grand totals with the use of: =sum([fieldname]) and I have used this in the past, but current report is erroring by giving the popup, asking for value entry on each of these I placed in the report. I'm guessing this is a...

All, Have working code at: http://www.access-programmers.co.uk/forums/showthread.php?t=176485 which creates and opens a query. The original query was an append query and I need the same from this query or way to save into table "tblMODfnr". All HOWTOs and helps I've read, do not show a way...

All, The normal use for this command is for and existing query. I have an Append (table building) query "qryBLDfnr" and need to mod it for filtering by date with:Sub Sav_Tmp(MyTable) ' Save values to the Temp Table Dim DATbeg, DATend, SQLstr, WHRstr DATbeg = TargetForm![tboxSDT]...

All, Have a set of nested forms/subforms in this order: frmMain => sfmMain => ifmTABset => sfmUSR => sfmSETcfg where sfmMain & sfmUSR are the control fields containing the subforms being called and the TAB control TabCtl0 resides in the TABBED form of ifmTABset. I am trying to open the 5th...

All, Have a form with over 189 controls on it and trying to automate the save. I currently use the following script to init the fields: On Error GoTo Err_Msg For Each ctl In Targetform.Controls ' 100 = Label, 106 = CheckBox, 109 = TextBox, 111 = ComboBox Select Case...

All, Trying to get a date WHERE statement to run to pull all records for the month. What I have is: Dim SQL_Str, DatStr, MonVal MonVal = Get_Month(TargetForm![cboxMON]) DatStr = MonVal & "/*/" & TargetForm![cboxYER] SQL_Str = "SELECT * FROM qryREPrev WHERE ([tim_ted]= like #"...

All, I'm writing a script/function to automated putting buttons on the screen. I'm running into a problem with var substitutions in my strings, which is necessary to make it run. Here is my code: Function Get_Btn(MyForm) Dim Wspace As DAO.Workspace, dbs As DAO.Database, rsDEST As...