Search results

Access 2000: Text1= Date Text2= Weekday Is it possible, using code, to convert the date in textbox1 to the corresponding weekday and place that value in text2?

[RESOLVED] Sql query problem (Query included) Operating System: Windows XP Pro Access 2000 (9.0.8948 SP-3) Problem Category: SQL query Greetings: I have a problem that I cannot solve. I have a form named “ALABAMA ARREST REPORT” on that form in a listbox named “List17” the row source is a...

I agree with your solution to this issue; is it possible however to conduct this process with code? By that I mean can you write code that will remove the picture from the media (floppy), place it in a directory, and link it to the .mdb table? The primary reason being, user friendliness. If so...

Insert and Resize Photo. Access 2000 Problem: I have a form named “Department Employee” on it is a bound object frame named “Photo”; I am having trouble writing code that will allow me to select a .jpg from a floppy, resize it to 162x216 Pixels and insert it into the bound object frame...

I have a flat-file front-end back-end access 2000 database that is used by 4 to 5 people simultaneously on a network. Each user uses a separate .mde file to enter data. The problem is that periodically record corruption occurs in the memo field of the form when two users are accessing the same...

Thanks Thank you "lagbolt" and "Cosmos75" that did the trick. Mshelley1

I am intrigued with your response , would you be kind enough to elaborate further as my experience dealing with menus is little. Thank you Mshelley1

[RESOLVED] Call VBA Code From Right Click Menu: Greetings: Currently the following code is set to be called via a DblClick on a list box item; is it possible to perform this function by right clicking the item in the list box and selecting a command rather than DblClicking it? Thanks Mshelley...

Does anybody know if it is possible to send text pages using MsAccess 2000 VBA? An example would be to send a page (via traditional telephone line) with a pre-written message by clicking a button on a form. Are there any third party applications that would that could be used in conjunction with...

[resolved] RG I discovered the problem and solution, Thank you for all your help you are the reason my problem is solved. Carbo http://www.mvps.org/access/bugs/bugs0031.htm

RG When I run the module I get a Compile error “User-defined type not defined” Here is a copy of my code. (Problem area in red) (Thanks in Advance) Function AutoFillNewRecord(F As Form) Dim RS As DAO.Recordset, C As Control Dim FillFields As String, FillAllFields As Integer On...

RG Could you provide me with guidance on the best way to call the module using a button. Thanks

try format(now(),"YYYY") or =format(now(),"YYYY") this will return current year "2006" Carbo

http://support.microsoft.com/?id=210236 RG The above link describes what I need; only I need to be able to perform this function occasionally like maybe using a button. Carbo

[RESOLVED] Is there a way perform CTRL+' with vba code in MsAccess 2000 Is there a way perform CTRL+' with vba code in MsAccess 2000 Carbo CTRL+' copies data from a field in the previous record to that field in the current record. Resolution: http://support.microsoft.com/?id=210236 If you...

[RESOLVED]Paste Errors ????? I am Stumped. Paste Errors ????? I am Stumped. -------------------------------------------------------------------------------- I am stumped. I have added a button to my form with the following code. When I run the code I get the "Paste Error" message. Private...

Need to loop .wav file three times. (See "Sound") (Not tagged in origional code.) Private Sub Address_Exit(Cancel As Integer) Address.BackColor = 16777215 On Error Resume Next 'If there is no matching record in communications do nothing. If IsNull(DLookup("[address]", "communications"...

[resolved] I worked it out.. Hope this helps someone else. Answer: 1. Like [Forms]![Form46]![month] is the modification to the query expression 2. Enter * in the combo or text box

Try repairing access using the installation disk.

Access 2000 I have an “unbound” form with a list box, a text box, and a combo box. The list box’s Row Source Type is a Query. The query’s criteria come from the textbox and a combo on the form. Once the information is entered into textbox and the combo box a macro is set to run on the combo...