- Modules / DAO / VBA

Thread preview

Thread	Last Post	Replies

Make table	03 Nov 2004 14:03 GMT	5
I am trying to make a table from code. The same SQL is working in a query, But when running the following in code - nothing happen (not even an error message)
IsLoaded	03 Nov 2004 13:50 GMT	2
Can the IsLoaded function be modified so that it will work with Reports and Forms? If so, can someone help me with the code? I would really appreciate it. Thanks,
Recordset and subroutine	03 Nov 2004 13:00 GMT	1
What am I doing wrong in the next code? Using ADODB I am opening a recordset of a table and with the subroutine I am wanting to get the values of some fields. I have defined first my own object (type) for the values of the
How do I know programatically if a table/field has 'Unicode Compression'?	03 Nov 2004 10:43 GMT	3
How do I know programatically if a table/field has 'Unicode Compression'? Is there a way to set it programatically via TableDef or Field object? Evan Camilleri
cannot update fields with spaces in fieldnames	03 Nov 2004 07:48 GMT	17
Using the recordset object, and a connetion object, I can connect to a database and add records, howevere where the fieldname has spaces, I am unable to update. Following is the code I am using in the onclick event
Why are custom functions inaccessible outside of Access?	03 Nov 2004 06:19 GMT	5
I have defined several functions using VBA to help limit duplication of code throughout my queries. Specifically, I am referencing DateSerial in order to calculate first and last days of previous months. However, I cannot mail merge or integrate into my accounting system any ...
using mde files in different operating systems	03 Nov 2004 04:42 GMT	1
I'm developing an Access database under Win2000. My clients have a variety of operating systems. I don't want to have to know what they are using and every time they upgrade. I can't have every combination on my own computers to develop with either. I am using late binding ...
Help! - "Module Not Found"	03 Nov 2004 03:54 GMT	1
I have Access 2003. I have a large database and was doing some work this morning. All of the sudden, when I click on any button that opens a query, I get an error message "Module Not Found". The title of the message box is "Microsoft Visual Basic".
I have to strip HTML tags out of a line of text	03 Nov 2004 01:21 GMT	1
ALL, I have to strip tags out of a line of text like <bold>..<Body> etc. I have to delete the carrots as well.. Thanks Much,
Showing all data from a field in a table	02 Nov 2004 23:59 GMT	3
Sorry for the re-post, but I just can't seem to get this to work. This is the SQL for my query: SELECT [tblBarge Information].BargeID, fConcatChild("tblBay Information","BargeID","Bay #","Long",[BargeID]) AS SubFormValues
Programatically Change Joins	02 Nov 2004 23:59 GMT	5
Is there any way to change field joins in an sql statement or query based on some criteria? For example: If the current month is January then I want to join TableA.Field1 to
Multiple Recordsets	02 Nov 2004 23:00 GMT	2
Is it possible to have more than one recordset open at once? I haven't found anything that specifically states that only one recordset may be open at a time, but every time I try and open more than one - Access gets "cranky" with me. ('97 ed)
Beginner's Help	02 Nov 2004 22:41 GMT	1
I am trying to add data into my table and am not sure of the correct syntax. Also, I am not sure if I used the correct syntax in opening a table - dbOpenDynaset. Here is a sampling of my code. Dim rstRaceHeader As DAO.Recordset
Opening a new mdb from existing mdb	02 Nov 2004 19:19 GMT	3
Is it possible to open a new mdb using Call Shell("command line for path to MS-Access and mdb to open")? If so, 1. can I specify the default location of MS-Access rather than fully defining C:\Program Files\...
save report in xls format	02 Nov 2004 17:28 GMT	1
How can I save a report in an xls format to a location chosen by the user? Thanks, Mark