Search results

Hi all, I am having a problem with this linked table(and the only table) in access which is linked to a database in MySQL via ODBC. the problem is that the linked table in access is read-only (I want it to be read and write). I have searched the internet and found that you need to have the...

Hi all I am having a problem trying to Use Access as a front end database and having MySQL as the backend and I am trying to export a table from Access to MySQL following this website: http://builder.com.com/5100-6388-1050135.html but I am geting an error (see attachment) I tried to create a...

Hi all I am creating a calender in the Access Data Pages and I was wondering if there is a way to check for whether the current year is a leap year with VBA? Thanks for your help!!!

Hi all I am using the Data Access page for creating a events page in calender format. I am setting it up so that the present month, and the following month will be visible on the web with each month on a different page. I am using list boxes to display the events for each day so that more...

Hi all I have a database which works great on Windows XP but fails because I am using code to get the user name and only works with Win XP that is: Environ("UserName") Could someone please tell me the code to use for windows 98? Thanks a lot scott

Hi all I have recently Upgraded from Office XP Professional to Office 2003 Enterprise edition. Before upgrading the forms would work without a problem, now every time I want to change a subform's recordsource I get error: "You entered an expression that has an invalid reference property...

Hi all Is there a way to shut down the computer with VBA? I am needing this so that the restricted user does not close the database and then start playing with the other files and stuff on the computer. Thanks in advance

Hi all I am having a small problem with a dlookup which is not looking at the date only (without the Datevalue function), but is looking at the entire field instead. with the datevalue function it is giving errors "Data Type mismatch in criteria expression" here is the code...

Hi all I am on the last parts of my Books database and am wondering if It is possible to automate the process of un-corrupting a database. here are some ideas I had: 1) after doing research I found that corrupted records have #Deleted in it and when refreshed will not go away. is it possible...

Hi all Should I upgrade my Office XP to Office 2003? Will the coding in the Office XP be different to Office 2003? will Major changes to the macros and Visual basic coding be needed when I change to Office 2003? what are the benfits for upgrading? Thanks in advance

Hi all Is there a way to cancel a record after half entering even without the primary key? (with coding, not the undo button on tool bar) I am having a problem with a unbound combo box and when the user starts typing in it, it will create a new record because its row source is sql code to look...

Hi all I am trying to make a entry form where if the user starts typing in a record that already exists, it will open a popup form that will ask if the user was entering this record. The problem with this is, when it appears it takes the focus. What I want it to do is appear and the form...

Hi all I am customizing the function keys and soon found that all the function keys have changed. the function keys are going to do different things in different forms and need to not have global shortcut keys (most of the time). here is my code: If KeyCode = vbKeyF11 Then...

Hi all is there a way to make the drop down list of a combo box appear when user starts typing in it?. When in a combo box, the F4 key shows the list, but I am planing on customizing the Function keys. Does anyone have any ideas? Thanks in advance

Hi all I was wondering if there is a way to use the like operater with the less then "<" and greater then ">" signs tried using: If Left([ISBN_Number], 3) Like [#00-#19] Then but does not work. Does anyone have any ideas? Thanks in advance

Hi all I am trying to make some code to change the input mask for a ISBN Number field when the user presses a key so that it will handle all ISBN numbers. The problem I am having is it will change on the first key press, but then I have to go into design view, or close form and reopen to make...

Hi all I just had a situation where I had a dlookup could not search in a field where it contains an apostraphe {'} (the button next to the enter key). I got around that by having the ascii code changed with the following code: If intKey = 39 Then intKey = 96 I used Mile's example in the...

Hi all I have a form which has two subforms with the same record source (via different Queries), one of form view and the other in datasheet view (to make it like an index). When I change a record in the datasheet subform it will change the same record, same field in the form view (which is...

Hi all Is there a way to make a textbox (or other control) set to null from visual basic? At the moment when I want to delete a value from a field, I have to code like this: txtTextBox.value = "" and then when I want to check for null value I have to do it like this: if txtTextBox.value <>...

Hi all, I am trying to make this code work for finding whether the Date_Sold has a value in it but do not know how to incorperate a "Not isNull()" thing in there heres my code: If DLookup("[Book_ID]", "tbl_Inventory_Each_Book", "([Book_ID]= me![Condenced_Book_ID]) and...