Search results for query: *

I've got a form for showing/editing my database records. One of the fields is City. I have a table which has two fields - the long version of the city name and the short version (LongCity and ShortCity). The City field on my form correlates to the LongCity version. I'd like to add a textbox...

Despite Access telling us that once you convert an Autonumber from Increment to Random you can't go back, we converted to Random. Now we really want to go back. I'm not sure how. We have a bunch of code and forms/reports written, so I can't just start using a copy of the db because all the...

I have functions in a report module and Access says it is not finding certain fields. The functions return #error without error trapping. The Err.Description is "Lien Database can't find the field 'OrigAmt' referred to in you expression." The report's control source includes all of the...

Each record in my database has about 40 fields that are used in several calculations. I created a form that uses a bunch of functions that do the calculations that I need. Because there are so many fields that the functions make reference to, I don't pass the values to the functions as...

In the Database Window I hid a form that I didn't think would have user interaction. Now I need it to be accessible to the user. How do I unhide the form? Much thanks - MSK

I'm setting up an old DOS program on an XP PC. When I run the DOS program, I get the message that it needs at least FILES=70. Used to be in CONFIG.SYS at the boot root, so I opened CONFIG.SYS at c:\. Surprised to see that it was blank, as are AUTOEXEC.BAT and MSDOS.SYS. Put FILES=100 in...

I'm setting up a small Excel VBA add-in so that as soon as I open or create an Excel file (the "target") it will change from Excel's standard colors to our company's colors (colors good for color laser and also that can be distinguished when printed on a b/w laser, etc). I tried...

Tek-Tips has been very helpful to me over the last few days, so (in addition to Supporting Tek-Tips) I am enclosing below a snippet that we find useful to perhaps help the people that actually provide the answers. While you won't find this code novel or challenging, hopefully you'll find it...

There is plenty of documentation on opening another application. My instance in Access VBA looks like the following: Dim oApp As Object ... On Error Resume Next ' Defer error trapping. Set oApp = GetObject(, "Excel.Application") If Err.Number = 429 Then...

Developing an Access app using VBA. There is an Excel spreadsheet which I am opening for a more detailed analysis of the selected record. (No problem opening Excel.) After opening Excel, I would like to be able to call a procedure in the Excel file's code module. (I am passing the index key to...