Search results

I have a subform which shows a query (dragged the query and dropped it on the main form). I can set the query sql so: CurrentDb.QueryDefs("qryReports").SQL ="SELECT...."But I can't get the subform to reflect the changes made to the querie's SQL unless the form is close and reopened. How do I...

One table (tblContainers) holds container sizes (fields: ID, Type, maxPayload). Sample data: ID Type maxPayload 1 A1 27,000 2 A2 29,200 3 A3 32,150 4 A4 25,500 5 A5 22,600 6...

Hi Folks, This one has me stumped. Using Win 7 32 bit Access 2010 32 bit, I can't get the property pane to open. Right-clicking the form or any of the controls and selecting Properties or Form Properties doesn't do a thing. How can I get the property pane to open.

Hi Folks, This one has got me utterly baffled, I will truly appreciate your help. I have a combobox with the following specs. Row Source Type = Value List RowSource = 1;test1;2;test2;3;test3;4;test4;5;test5;6;test6;7;test7;8;test8;9;test9;10;test10;11;test11;12;test12 ColumnCount = 2...

Hi, Does anybody know of a method to take a picture with a web cam that will work on Windows 7/8? WIA isn't supported, and I haven't managed to find a way to do it, although I've spent hours searching.

Hi, I was asked how to setup a connection from an Access front end to a MySQL back end using SSH. I can connect successfully to the back end using the odbc driver, now we were told that access to the back end server will be limited to fixed IPs (which most of our users don't have) or thru SSH...

Cheers all Experts, I am currently using the following code to relink password protected BE to a FE, as the comments clearly say it will not work with multiple BE. How can the code be adjusted to work with multiple password protected BE? Function RefreshLinks(MyDbName As String, pwd As...

Hello all Experts, I'm using the following function to hide the access background, the problem I'm experiencing is that although it works well with forms, reports open but are not displayed, in other words access freezes. Here is the code: Option Explicit Global Const SW_HIDE = 0 Global...

I need a function that will accept a string and return one word from that string, the word I'm looking to extract is one of 13 words. All help will be appreciated.

I've read a lot about using FE/BE. What I'm not clear on is the limitations: What will happen if multiple users attempt to edit the same record? Are there any limitations?

Hello All Experts, Here's my latest question: I have a table I use to store archived records, the records originate from two tables (they are joined on one of the fields). This part works. The SQL I use is: INSERT INTO tblHistory ( SellerID, Surname, FirstName, Phone, Cell, Fax, Email...

I followed the instructions for Synchronizing Two Related Subforms on a Main form at http://www.fmsinc.com/microsoftaccess/forms/synchronize/linkedsubforms.asp. For some reason the hidden textbox doesn't get updated as I move from record to record, and therefore the whole-thing doesn't work...

I'm using the following function to count the number of selected records in a datasheet or continuous form view. Function CountSelectedRecords() Dim i As Integer Dim F As Form Dim RS As Recordset Dim intSelRec As Integer On Error GoTo Err_Catch ' Get the form and its...

I'm trying to set a DAO recordset to the following query: SELECT DISTINCT Temp.ID, Temp.DateUpdated FROM (SELECT DISTINCTROW B.ID,[P].[DateUpdated] FROM (tblBuyers AS B tblApartments AS P)as Temp WHERE (([Temp].[DateUpdated]) Between ([Forms]![frmDateRange]![txtFrom]) And...

Hide Page header on first page of every group Hello all experts, I have a report which is grouped by a field called name. I want to hide the PAGE header on the first page of each group. I tried a method that I found at...

Hello to All, I'm trying to find a setting for emailing in cdo that will display custom text in the recievers inbox "From" column. So far everything I tried didn't help, in the From column the receiver sees my gmail address minus @gmail.com. This is the code I'm using: Private Const...

Hello all Experts, I'm trying to use DoCmd.OutputTo to save a report as a PDF file. The trouble I'm having is that it seems to ignore the formatting set in VBA. In this case if a certain condition is true the PageHeader is hidden, the problem is that DoCmd.OutputTo prints that header even if...

Is there a way to print the page header on every page but the first page of each group (there I want the group header)?

I'm trying to create a new document based on a template which is stored on a network drive, to merge data to. It will not load the first time, since there seems to be a Word 2010 bug, that Word is still initializing. It succeeds after several tries. How can I create a loop that will try to...

Hello All, I'm dealing with a Real Estate db. One table (tblProperties) holds all available properties and their information, another table (tblRequests) holds all clients and what they're looking for. I need to create a report for each client (from tblProperties) based on the information...