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

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

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