I'm starting to learn and use VBA & SQL.  I've read that one of the
advantages to using SQL directly in the record source of a report is that end
users can't easily change the query (since there won't be one in the Query
object list).  To get used to using VBA, I'm using DoCmd in ...

Hello, to anyone who is willing to help, I am in desperate need of
little guidance with an issue I am facing.
I was hoping that I could be
pointed in the right direction for help on a Microsoft Acces

In VBA and Access I am using a textbox to enter criteria to search a field
using sql recordset.
How can I search for a percent symbol or a single quote in the field?
Thanks in advance

 two of my fields in the table are date type i.e. "from_date" and
"exp_date" i want to perform a date range test using another value from the
form to check if that new value lies between these two dates or not and
retrieve all the records from the table where it lies. I m using VBA ...

i have a large excel VBA project delivered as an ADD-In and was looking into
moving the data portion into access.
Q: before I begin - What is the best way to hide the access file and app ? I
think the file should be open but do not want the "user" to see it.  Also do

Would appreciate any insight into this one.
I have a sub from that allows the entry of some data. The table that it is
built on is an ODBC linked SQL server table.
The sub form allows the the entry of two foriegn keys in the above mentioned

My query name is “Salidas”, I have a column named “Tipo” in this column
exists tree kinds of entries “nota” “factura” and “S.Int”, I want to define 4
different criterias using VB: 1.”nota” or “factura” 2.”Factura” 3.”Nota”
4.”S.Int” these criterias are going to be linked to some ...

here is the code i m using to test a FORM.FIELD BETWEEN TABLE.FIELDS
SELECT * FROM rentals WHERE (#" & Me.txtfrom & "# >= from_date) AND (#" &
Me.txtfrom & "# < exp_return) AND (carreg='" & Me.txtcarreg & "')"
and it generates the following error

                We are developing a visual basic application that
compresses  a bitmap file into jpeg file . We are not getting any solution
for compressing a bitmap file into jpeg file in visual basic. Eventhough we
had some solution ,  We are getting a problem with that solution  ...

I have a SQL statement that is supposed to take the selection of a listbox
(lstTitle) and display all the records in tblSongs that match the criteria.
In the following code, I get a message that it cannot execute the strSQL
statement. I also tried the docmd.opentable "tblSongs" ...

I have tried repeatedly to ge the immediate window working and have never
succeeded.  I realize this isn't rocket science. Following the instructions
in the help file online from MS, I entered the following line:
Form_frmSomething.Form_Load

I REALLY need help with an Elseif statement in a query.  I am receiving 3 or
4 tables which I convert to access and then have to create tables which will
assign about 300,000 rows with classifications which will be used for groups
in  Crystal Reports.  For each set of reports, I ...

I noticed Access crashes in some situations. This has been happening for
about a month now and I sent the error reports regularly.
In the meantime I think I figured what goes wrong. One situation I
identified is the following:

 two of my fields in the table are date type i.e. "from_date" and
"exp_date" i want to perform a date range test using another value from the
form to check if that new value lies between these two dates or not and
retrieve all the records from the table where it lies. I m using VBA ...

I am trying to reference a field in a subform.  Here's the function I used in
the main form and it worked fine, but I can't figure out how to include the
subform reference.  My subform is "Contact Types"  and the field I'm trying
to reference is "ShippingPostal".