Advertisement

1 - 10 of 80 containing alltags:("vba/sql") (0.003 seconds)
OK, folks... I have beaten this around pretty much to the point of frustration, and perhaps I am missing something very simple. Scenario:  I am building an app in MS Access 2000 where one of ...
Zones: MS AccessDate Answered: 08/24/2003 Grade: A Views: 0
I have a table called tbl_booking with the following fields Booking ID Room ID Start Date End Date I have created a calendar form based on the minicalendar db so I have a text box represen...
Zones: MS AccessDate Answered: 03/29/2004 Grade: A Views: 0
This code was kindly written for me recently by  XL-Dennis and works great except for the bug I've just found. Please look at the 2 necessary files in EE.ZIP at  http://homepage.ntlworld.com/ahros...
Zones: MS ExcelDate Answered: 04/04/2005 Grade: A Views: 0
I keep getting a syntax or missing operator error on this. The statement below is filling the source for a recordset.  I'm using this SQL statement in VBA. Also, i'm using the ASCII Chr(34) i...
Zones: MS AccessDate Answered: 01/25/2006 Grade: A Views: 0
I have a program that contains this coding.  I need to make some changes to this but didn't write the code and am not familar with some of it and what it is doing.  Can anyone look at this and give...
Zones: MS AccessDate Answered: 01/31/2007 Grade: A Views: 0
Experts: I need to hide a field in my subform when I hit a command button on the main form. Can you please help me with the syntax on line marked ////////.....Thanks Private Sub lblDoSomethin...
Zones: MS Access, Access FormsDate Answered: 09/08/2007 Grade: A Views: 0
Hi, I have a SQL query that runs from VBA and selects data from two tables, the query does not return any data.  If I cut and paste the query from the immediate window into RapidSQL, I get data b...
Zones: MS ExcelDate Answered: 11/05/2007 Grade: B Views: 13
Hi, I'm sure the answer to this question is somewhere in this database already, but I am having trouble finding it.  I am new to stored procedures. I created a stored procedure in SQL and got...
Zones: MS AccessDate Answered: 01/03/2008 Grade: A Views: 88
Hi All, This is urgent. Please help I need a report done in MS Access that will list the SubjectContactIDs who have NOT been contacted from more than 31 days from the date NOW when the system i...
Zones: Access Reports, Access Forms, Access Codi...Date Answered: 06/03/2008 Grade: A Views: 0
Hi, this is my first posting to experts-exchange. My Problem is, I need to put the result of an sql statement into a column of a table. The statement has to use data of another column of the same ...
Zones: MS AccessDate Answered: 06/06/2003 Grade: A Views: 0