Search results for query: *

You could set up a function to perform the concatenating and reference that in a query. Function Concat(ID As String) As String Dim Rst As DAO.Recordset, MySQL As String MySQL = "SELECT * FROM tbl WHERE tbl.ID=" & ID & ";" Set Rst = CurrentDb.OpenRecordset(MySQL, dbOpenDynaset) Rst.MoveLast...

That's good to hear. Good Luck.

Initially, my instincs say you should not be able to enter a value in your primary key as that should almost always be an autonumber field that is hidden from view. With that said, you should be able to set EntryNumber index to Yes (No Duplicates) and Access will not allow duplicates. But...

Is EntryNumber a Primary Key? If not, set it to be your Primary Key and it will not allow duplicates.

This allows the user to determine how much and what they want to view. It's an appointment screen so the user can choose the time increment, number of increments to view, how many columns to view, etc. In the end you have a spreadsheet like form with appointment information shown in the cells...

I have an appointment calendar that when opened determines how many time slots to show and creates a grid based on the user choices. In Access 2007 & 2003 it is lightening fast taking less than 1/2 second to load even the most complicated choices. In Access 2010 it takes 15 seconds, OUCH! The...

Your not alone, I also get the message (although on occasion I don't). As with you it occurs if I simply open a database from the explorer window even though no code is set to run.

I am trying to stop the API dialog box that pops up when I'm loading a .jpg picture. I tried suggestions from Dev Ashish and used his code www.mvps.org/access/api/api0038.htm , but it didn't really help (maybe I need to add a dll reference or something, I used it straight as-is). I tried...

I have a report with a sub report that also has a subreport. All looks fine in Access and taken individually or just a single level subreport, all looks fine (as well as can be expected) when I export the .RTF to Word. But, when I try to export to Word with the 3 levels of subreports, I get...

So far I'm 3 for 3, you tek-tip pro's are awesome. I'm trying to export a report to microsoft word. I have all fonts set to Times New Roman, but on the outputted RTF every few words is outputed as Arial. Also, when this occurs the RTF file adds a CR/LF after the Arial'd word. If I change the...

PHV you have my eternal gratitude. That solved it! Could you explain the meaning behind the number after the .connect command? Thanks.

Thank you for your reply. I'm not sure how to use it. Here is the code that checks for back end links: ' Tests a linked table for valid back-end. On Error GoTo Err_Form_Open Dim strTest As String, db As DAO.Database Dim td As DAO.TableDef Set db = CurrentDb For...

I have successfully used Microsofts code 'How to relink back-end tables with the common dialog control in Access 2000' to relink my backend (their Article ID : 209862) with a back end that is not password protected. But, when I password protect it the code first says it can't find my backend...

Tranman, I made the adjustment to the registry as you suggested to disable the importing dialog box when importing a jpeg into a form, but I still see the box popup. Do you have any thoughts or suggestions? Thank You. Bill Meyers

Thanks PHV and AceMan1, you solved my troubles and taught me yet again some new code. I never tried passing multiple criteria in a dlookup.

Thanks for the quick reply, I can tell your close, except I made a mistake. The order type is an integer and I think, because of this, I'm getting a type mismatch. So, can you tell me how the code should look with that change. Thanks.

Table name CustomerOrders Autonumber CustomerName type text OrderType type text Thanks for the help

I have a table with an autonumber primary field (so I can cascade update many other tables and so I can't remove this required index) a 2nd field that is a customer name and a third field that is a customer order. I can have many instances of the same customer, but I only want 1 instance of...

Thanks. What I'm really trying to do is keep things looking clean in case a user opens a form with the intention of adding a record, but then at the last minute decides not to. It's not something that should happen, really. Thanks for the help.

Thanks again for the suggestion, unfortunately it yields the same result as I was getting. Is there simply some VBA code that's something along the line of 'ON FORM CLOSE' so I can bypass my data checking? I am very new to using VBA and I am trying to use the MSDN on line guide with little...