Search results

Agreed. Pretty simple, jsut make sure your child/master links are proper.

The toolbar has an option to export to Excel. Does that work? Please post the relevent code.

OK, this function should work for you, but has not been thoroughly tested. It assumes that you will always have the designations h m and s in the input field, but does not assume any length of the values that precede the designations. There may be a better way, but this does seem to work for...

Rob: Set a watch on the variable in the module. Place a breakpoint at a conveneint spot in the code in the module in question, and step thru the code when the form opens. Do it again when the other method you referred to is called and you should be able to determine why it is changing the...

Any variable value is null until a sub or function sets it to a value. That will remain its value until it is reset by code, or when the function stops running. Modules are not 'running' when the app opens until they are called. Place a breakpoint on the code in the module, and step thru the...

When it goes out of scope. Which can happen for many reasons, but basically the code that set its value is finished running. Have you stepped thru the code to see what is actually happening? ??

Many ways to do this... one way: Create a dummy form that opens via an autoexec macro upon startup, and set the OnOpen event to insert the date/time into the log in field in your log table, and then sets its visible property to no. In fact, just design the form so that it is always invisible...

First, do not use macros. Exception: Autoexec macro. See: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=547442&Main=547442 What I might try would be to link to the text file as a linked table. Then run two queries against the table, the first would be an update query, which would...

Update queries run the same as any other query. To shut off the warning, SetWarnings to false. Suggest you do NOT use macros for anything other than maybe an autoexec. see: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=547442&Main=547442

public To reference code on another form it must be declared as a public sub or function.

I think you may have a basic design issue with your tables, as I see the same fields in more than one table. Normal design would link via a foreign key field. Assuming blindly that your design is OK, simple input parameters work something like: SELECT TableThree.[Detector Factor] FROM...

What 'doesn't work'? What type of query is qryExport?

Hth Ok, here you go. Probably a shorter way, but it should work. :o DELETE Table9.Postal , Len([Postal]) AS Len , Mid([Postal],1,1) AS [First] , Mid([Postal],3,1) AS Third , Mid([Postal],5,1) AS Fifth , Mid([postal],2,1) AS [Second] , Mid([postal],4,1) AS Fourth ...

Sorry, I just saw where you want to DELETE all the bad data, not try to clean it up. Will think about it.

Create an input mask for that field in your table. "L0L0L0" Should allow only Letter Digit Letter Digit Letter Digit

It would be pretty weird to get a decrease in performance. You should be getting a significant increase, since all query parsing should be occurring on the server. I have never been able to upsize to SQL Server without much tweaking, and many queries will not upsize correctly, and have to be...

MSACCESS.exe Usually installed in folder: C:\Program Files\Microsoft Office\Office10 depending on version.

If you mean that you want to display account info in a chart, I would start with the chart wizard.

It should be doing all of the query parsing on the server, returning only the resulting dataset.

If it ain't broke, ...... Not sure what you have in the front-end, but if the relationships are set up properly in the back-end, I would not worry about what shows up in the front-end window, unless you have additional tables in the front-end. Is this creating a problem? If so, what are the...