Search results for query: *

Hello: I have Windows 10 and Office 2016 (standalone) on a metered connection to the Internet, and am mostly offline. I have created an MS Access 2016 application and can't disable the "Updates Available" banner, which appears every time I open the app. I can click the "x" to close the...

Hi: I am now working as a consultant for small businesses. Should I deploy my Access database solutions to them using Runtime or should I have them get MS Access. I don't think any of these clients are the type that will want to spend any time messing with code or altering the database. What...

Hi All: I have gotten LOTs of help over the past few years on this and other forums. So...Below is a solution to the Error 3188 (when saving a memo field with over 2000 characters) error - and, by george...it actually works for me. The idea - cut the memo text into sections of less than 2000...

Hi all: From a ComboBox "afterupdate" event in a form, I requery a subform (in a container), based upon the ID of the record the user chooses (me.txtUserADID). This worked fine in Access 2003. The query - at the query level also works fine in 2007 (if I type in the ID) - either in the query...

Hi: My code is as such: me.cboTest.column(0).value = 1 me.cboTest_AfterUpdate the "After_Update" line elicits an error message. I've also tried using "Call After_Update"....any ideas? thank you! Karen

Hi: I have a form in Datasheet view. It used to be that one could just add a new record by typing stuff into the blank line at the bottom. Now there isn't a blank line at the bottom, but I still have AllowAdditions = Yes. Any ideas why? thank you, Karen

work with an Excel file (from within Access vba)? what about other Excel specific vba functions? Where can I read about this? (had hard time finding via google) thank you, Karen

Hi: I am using the following code which creates a text file with the Courier New font: Print #intFile, strTest & strMID & strAssy & strDescription & strQty & strTest1 & strUOM; "<FONT=Courier New>" However...I get this output - columns are lined up but I get the fot text at the end (after...

Hi: I have a query that I am exporting (manually at the moment) to text. The fields and widths are as follows: test 1 MID 8 Assy 6 Description 40 Qty 5 test1 3 UOM 2 I'd like to make sure the description field is always 40...

Hi: I am using a "Save As" in Access vba. I want to automatically overwrite the current file - eliminate the msg. I've tried Docmd.Setwarnings False, docmd.setwarnings (False) and application.setoption "Confirm Document Deletions", 0. After my "SaveAs" command, I set command back to True or...

Hi: I am exporting an Access 2003 qry to a fixed width text file. One column is 40 max characters wide (some records are 10 characters - some 35, etc for this column). What I've found is that as this column varies, the starting point of the next column also varies - so the fixed width isn't...

Hi: I originally had a set of procedures within a form working well for a custom collection of controls with tags. The controls all have the tag "Contract". When I move all of my procedures from the form to a module, I get the error 2467 (Application-defined or object-defined error). Any...

Hi All: I have a query with a Sum in it. Maybe for me, DSUM works the best, but I have heard it is slow so I'm trying other options. So now, I've got a Sum field in my query, and tried using First for all of the other fields (instead of Group By as I have a memo field), but in my Continuous...

Hello: I am getting a "No Current Record" error when I advance to the last the page of my report. I know there are more records. In addition, this error message does not seem to be coming from one of my procedures (it reads differently than my standard error trapping messages) any ideas...

Hi: I have a query (which I would be happy to post if need be). SOMETIMES, I get the "expression typed incorrectly or too complex to be evaluated" error. I have a main table "PROJECTS" in a one-to-many relationship with a table "CHANGEORDERS". If I run the query for a project that has records...

Hi: I am printing out a 1 page report which is within margins. There is a subreport - a list of names - within the report. When I print out this page...it prints out the same # of pages (of the same thing) as there are records in the subreport. The first page has the header on it. The rest...

If I put my tables in a "backend" database on the network - and secure the directory (Active Directory), I understand that users won't be able to directly open that directory. However, I am wondering - would they still be able to open the tables via an Access front end (given that I allowed...

reference thread703-12139 I am using some code in a report text box as follows: =Concatenate("SELECT [PDNNum] FROM [tblTransPCBData] WHERE [Transmission Line Name Counter] = " & Val(Reports!rptTransLineListAll!txtTransLineID)) Note that sometimes [PDNNum] can be a null or empty field. I am...

Please note: I accidentally posted this in the Access Forms forum instead of the Queries forum, so am reposting.... I have a query for Total Customer Minutes that combines Event Cust Minutes and SubEvent Customer Minutes. Every time I run the "Total" query, I get the "Enter Parameter Value"...

I have a query for Total Customer Minutes that combines Event Cust Minutes and SubEvent Customer Minutes. Every time I run the "Total" query, I get the "Enter Parameter Value" message box for qryBreakerSubEvents!SubEventsCustMins. I've been reading through other postings about similar...