Search results

The following VBA code searches for the serial number of an item in flat-file table. What I need is to modify the code so that if a match is found for the serial number the message box will show the information in the “description” column of the same record. Table has columns as follows...

Greetings: I have been using front-end back-end database, which consists of three .mde files connected to an .mdb backend on a Windows Server 2003 Windows XP Professional network. The database is a flat-file. Because of problems associated with record corruption, related to multiple users and...

[RESOLVED] Problem With ConvertingCurrencyToEnglish Greetings: Access 2000 Windows XP Pro I have a problem with the following module; “ConvertCurrencyToEnglish”. Its function is to convert the number in a textbox named “TOTAL LICENSE FEE” to English on a form. The function is carried out by...

[RESOLVED] Problem with .listcount When i run the following code the List62.listcount shows 1 more than the actual value. In order to get the correct value I have to modify it to List62.listcount-1; the problem with this solution is if the listcount value is 0 the listcount shows -1. Someone...

[RESOLVED] Total Days Between Two Dates. Access 2000 Greetings: I have a form that has three textboxes and a button. The first textbox named “Date” contains a previous date, the second textbox named ”EndDate” will contain the current date. The third textbox named “TotalDays needs to...

Access 2000 Greetings: I have a form that has three textboxes and a button. The first textbox named “Date” contains a previous date, the second textbox named ”EndDate” will contain the current date. The third textbox named “TotalDays needs to contain the total number of days between “Date”...

The follow vba code fine except for the date portion, it should only run after July 1st of each year. So the date portion is apparently not coded correctly. Can anyone help? Private Sub Command0_Click() If IsNull(DLookup("Name", "Count_CreditDef", "")) = False And Date >= 7 / 1 / Format(Now()...

[RESOLVED] Environ$("USERNAME") and Access 2003 How do I use the following as the default value of a textbox in Access2003? Environ$("USERNAME") Resolution: Create Module and insert the following code: Option Compare Database Private Declare Function apiGetUserName Lib "advapi32.dll" Alias...

Access2000 Greetings: I have a list box on a form that gets its data from a query; one of the columns contains a number value. I have a textbox, also on the form, which needs to display the sum of the numbers in the list box column. Is that possible? The listbox name= list8 textbox name= total...

Greetings: I am looking for a program that will repair a MsAccess 2000 .mdb file. So far all I have been able to find is those that repair the tables, does anyone know of a program that will repair the entire file including the forms? Thanks Mickey

Access 2000 WinXp Pro Greetings: I have a small access database that I keep on my thumb drive, the last time I closed it I removed my thumb drive before it finished saving and I got the windows was “unable to save” dialog box. Well, the next time I tried to open it, it would not open; when I...

Is it possible to copy the current record on a form to a different table? Example: Form Name = Training Orders bound to a table with the same name. 2nd Table Name = History I need to export certin fields from the Training Orders Form into the History Table. Below is the way I am trying to make...

I have a form that takes sever seconds to load, due in part to the number of records I suppose, however I would like to create a progress meter (form?) that will run while the form is loading. I have tried several different suggestions but none work. Can anyone help me? Thanks Mickey

Windows XP Pro Situation: I have a form named “COMMUNICATIONS” connected to a flat-file table named “communications” There is a textbox named “unit” which contains an employees Id number and another textbox named “ActivityCode”. Additionally, a listbox named” list0” which is connected to a...

Operating System: WinXp Pro Access 2000 (9.0.6926 SP-3 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, rename it to the current record number, store it in a...

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...

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...

[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...