Microsoft Access / VBA Forum

Hello All, I am having trouble with this forum I am developing in Access; I have two combo boxes, one containing the Director info, and the other containing the Manager info. Now what I want to happen is when someone selects a specific Director when they go to choose the Manager only the managers assigned to that Director to appear. In the...

I'll preface this question with my assertion that I'm not intellectually challenged...(if you ask my wife on a good day she'll probably agree with you too) However, this problem is making me feel that way. I have some data in a QUERY. The columns of interest are: INTERNALID, NUMBER, etc.... A, 100

Access has me flummoxed again (nothing new in that). I added menu buttons to a form using the command button wizard on the tool bar. They worked fine. You can see the "onclick" event under "Dipslide Add Record" below. Then when I went to a second form, accessing a different table, and tried to add the same button all I got was an error...

Hi all, I'm using Access XP 2002. I'm trying to put the control Microsoft Flexgrid 6.0 onto a form. However, whenever I try this, I get the following error..."You don't have the license required to use this ActiveX control". How can I fix this error so that I can use the Flexgrid control under Access? If this is not possible, could anyone...

Table Users FName(text), LName(text), UserID(number) Table Correspondence. Date(datetime), msg_From(number), msg_To(number) Table Users Data John, Quincy, 1 Jane, Doe, 2

I'm pulling what's left of my hair out. I'm trying to check a memo field on opening a report. If the field has "value", I'd like to change the fields back color. If it's "Empty", I'd like to leave it white. (i.e. if their is data in the memo field, I want it highlighted in yellow.) I've tried isnull, isempty, ="", all with no luck. I'd...

Here's what happens. I created the query below in a copy of my BE & it works fine. But in the FE: If I enter query into SQL view & hit "!" I get correct results (a list of families w/nonzero balance). However, every time I try to save it Access crashes (error report &

I'm having a few problems with strings and I think it's as to how they're compared. for example this query: update set = "" where not in (select countrycode from country) does not update any records, despite the fact I know there are country code

There's no zinger here:).Just wondering if your following the development and direction of these two open source systems which are now under MySql development.(MaxDB is new version of SapDB). RAC v2.2 and QALite for all S2k versions. P.S. We will probably bundle msde/QALite/RAC for use with Access and MySql.

Hello, In an Offers DB, I have a form with two fields BeginDate and EndDate. When clicking on a button, it opens a continous form with a DoCmd.OpenForm and a criteria based on the 2 dates (i.e. it shows all the offers that were created between the two dates). What I would like to do is to open a "simple" form where the previous...

I have a db I recived from my school district with parent names (stupidly) maintained like: Parent_Name -------------- Doe, John Doe, John & Jane Doe, John & Deer, Jane I want an update query that will fill four fields:

I currently populate a form based on a query. 1)How do I create a report that displays only the current record's fields and not all records in the table? Thanks Tim G

Hi, I have very serious problem with query in Access. I have, in my DB, a lot of forms with some buttons that I use to do query. When I press that buttons and query start I have "Invalid Argument" error because memo field lenght is greater than 128 char. If the type field is memo why I have this error? How I make to resolve this problem?

Hi I am trying to use the internet transfer control to send some data to a site. I want my MS ISA proxy server to keep the connection alive. What syntax should I use to send the 'keep alive' data to the proxy server? Is any of the following any good? objInet.Execute "http://wwww.mysite.com", "POST", "Some Data", "Content-Type:...

Hi, I 'm using oleBlob.Action = acOLEInsertObjDlg to insert OLE objects into a database but when this line is executed I get error 2793 'E & S Database can't perform the operation specified in the Action property of the Visual Basic procedure you're trying to run.' If I hit debug on the error message and then hit F5 the code continues...

Hi all! Is there a way to manipulate default value at table level, with code? I want the user to be able to alter the default value of fields in a table, without access directly to the tables.The tables are linked to the frontend. I am using Access 2002. Sigurd spamblock remove 3x to email.

Hi, I'm looking for an editor for an Access Database. I've used UTE in the past, and looked a few others, but now I need a slightly more powerful editor that will let me add and delete complete tables and fields rather than just the records therein. Preferably, a web-based, ASP app. Any ideas? Links? Thanks.

This may be off topic and if it is I am sorry. I just installed MD Office 2003 and left Access XP (2002?) on the computer. If I try to open a database with the new Access I get an error that "Microsoft Jet 4.0 Service Pack 8 or later" must be on the machine. Microsoft Update doesn't show it as a need download and the highest Service Pack I...

All I made some changes to A2000 mdb whilst working in A2002.I did not convert the file format to 2002.Now it is released some forms that I didnt touch are taking 15 secs to open whereas in the original they took 2 secs. The database compiled OK I tried deleting and recreating indexes to no avial Compact and repair no effect It uses linked...

Hello, Could someone point me to the syntax required to detected whether a particular table (say tbl1) and a particular Query (Qry1) exists in the catalog? Thank you in advance. Cheers!

Struggling a bit here & would be grateful for any help. I have a table which has a list of people in it. Each person has a unique ID automatically allocated by Access but also belongs to one of 5 Groups - call them A to E. I'd like to generate a further automatic reference number based on something like Group/Unique ID so when I create a...

I am looking for a switchboard creator alternative for my MDB. Can anyone help me? Thanks for your help, Mark

Hi, I'm developing a CRM (Customer Relationship Management) system in MS Access. I have 2 tables. The first is a customer master file, the second is an activity file. A key function of the system will be to track when it is time to follow up with a customer. Sometimes it's for a specific reason, other times it's just a routine "keep in...

ACCESS 97, Pessimistic Record Locking!??? Does Access 97 allow record level Pessimistic locking? In other words, when user A is editing a record (has it locked) and User B tries to edit it (attempts to lock it), user B will get an error saying this record cannot be locked now. It seems like Access 97 is doing optimistic record level...

Hi I am using the Internet Transfer Control as follows; strData = "Some data" strHeaders = "Content-Type: application/x-www-form-urlencoded" & vbCrLf objInet.Execute strURL, "POST", strData, strHeaders I would like to keep the internet connection alive. What would be the syntax