John, thanks, I tried it moment ago. This code returns Run-time error '3078' (can not find "tblOutput"). After I created table named "tblOutput" it doesn't...
John, Few words about remark ... Each table can deal with at least one or more block (create, change or delete). So empty "Delete" block in my example is...
Well, it's either not finding any tables that begin with the letter "r", or those tables don't have the proper data in F2. LIKE should work to test the table...
The below statment fails with syntax error, DO NOT pay attention to the stuff in the the where clause, that is tested and works, prob is when i use more then...
You need only one SET keyword: mySQL = "Update DC set dc_pm = '1', dc_am = '1', where dc_name ='" & Forms!Doctorcalender.H_dc_name & "' and dc_dav = # " & ...
John, it all works! :))) I only changed "=" to ">" in your select Set rstIn = db.OpenRecordset("SELECT F2 " & _ "FROM [" & tdf.Name & "] " & _ "WHERE Len(F2 &...
Thanx John, I had difficulty finding examples of multiple arguments being set........ --- In MS_Access_Professionals@yahoogroups.com, ... buffalome90210 ... ...
Yuriy- Silly mistake on my part. Glad you got it working. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications ...
John, Yes, I am doing this in Access 2007. Please excuse my ignorance but I'm not having much luck with the DoCmd. I did manage to get the 'rptCartDetails' to...
Hello Everyone, I'm working with Access 2007 which makes it easy to embed macros in forms, reports, etc... Is there a clear advantage to this vs. creating ...
When you create an MDE, all DB properties, User Level Security permissions, references, etc. are copied from the MDB. If you just import all objects into a new...
Jesse- Just when I thought macros were going to be dead, the Access dev team resurrected them! If you're comfortable using macros, then embed them in the form...
John, Keeping tons of macro modules organized is turning into a big a chore, that's why I was wondering what people found easier. I've mostly been using Macros...
John, That worked, thanks! My question is that when I type the command manually an extra set of " automatically appears after the & Me.txtCart part. It doesn't...
Jesse- You would have to copy and paste the "bad" code for me to have a clue. You probably had an extra " somewhere, and the VBA editor is just trying to help...
John, Private Sub btnViewCartDetails_Click() DoCmd.OpenReport "rptCartDetails", acViewReport, _ WhereCondition:="CartID= " & Me.txtCart" End Sub Note the extra...
Hi Bill, Thanks for your answer. One of the reasons I am asking about this is that I am soon going to release a Demo version and could use the benefit of this...
Hi Jan, Could you upload your "Northwind template form for employees" to the Group Files 2_AssistanceNeeded folder so we can see it? One point that sounds bad...
Pat To be brutally honest, I have never built a product for resale. The ones I have built were all for free. Some open source, some not. I don't make my living...
You are most welcome Bill! Thanks for kindly conducting the verification and providing the confirmation. Best wishes, A.D. Tejpal ... From: Bill Mosca To:...
Pat, Something that's worked for us in the past (with other applications, not necessarily Access) - is to give them a full blown version of your product under...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Feb 2, 2009 4:57 am
69601
Hi Pat, Bill is right, properties must be created again when databases are imported. I run code that checks for them when the main form starts up -- it...
I have a need to compare 2 columns in the where clause. The date and time are 2 separate columns in the table. However, in order to filter some of the records,...
Hi Bill, Thanks for your insight and help. For my paying customers I will will make the Application open source. But for my free Demo Version I just want to...
Hi Jesse, Thank you for your help. That is very interesting thought. Perhaps my brother the attorney could help me with that. Best Regards, Pat ... ...
Hi Thomas, SELECT a.[PKField], a.[Field2], a.[Date_Field], a.[Time_Field], b.[Date_Field], b.[Time_Field] FROM [Tablename1] as a INNER JOIN [Tablename2] as b ...
Pat- CurrentProject has all sorts of properties: AccessConnection AllForms AllMacros AllModules AllReports Application BaseConnectionString CloseConnection...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
