Recent content by mshelley1

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

Thanks for the reply. By flat-file I mean that it is non-relational; all data related to each entry is in a single row.

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] Thanks "Oldsoftboss" Mshelley1

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

This is what I have but it does not work. TotalDays.Value = DateDiff("d", “txtDate”, "EndDate")

[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 application I am referring to was written a number of years age in access 2000, however when I ran it a machine that had access 2003 It does not work. In your opinion, do you think that it is because the application was written in Access 2000 and has not been upgraded? Perhaps the function...

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

What you say is true if you were using Access 2000 but this does not hold true for Access 2003, This function simply does not work at face value. Thanks

[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