Search results

Is it possible to update a sub-form that was created from a query that has been updated since its initial creation? Or is my only option to remake the subform?

Fixed by copying a working checkbox from another form

Its giving me a whole different RTE '-2147352527 (80020009)'

Thank you.

I am trying to set the value of a Checkbox inside a If/Then function in the Form_Load() function, but I keep getting a run time error. What is the single line of code that will set my check box to true/false? I expect something along the lines of chkSent.value = True but it offers me Run Time...

I have a subform that will only display a single record (data is set so there can only be a single active record). How can I remove the record count bar at the bottom of the subform?

if you're doing a lot of formatting, may i suggest the "With / End With" command? With xlApp If .Cells(1,i).value Like "H*" Then .Columns(i).Select .Selection.numberformat =~~~ .Cells(1,i).num ~~~ End If End With

I'm attempting to export a table that is compiled via queries to be used as a report. The table has 17 fields, and only holds 50 records(+/-5). When I run export code it gives me the 3190 error : "Too many fields defined". The error occurs right after the section of code in red. strTable =...

I have the following libraries enabled, and its still giving the same error on the same line. EDIT: solved by adding ActiveX Data Objects 2.8 Library

I'm using this as an excuse to not only build a cleaner database, but to get rid of the mess I made when I first started on it.

I keep getting a "compile error: User Defined Type not defined" when I try to run a concacnation function. code being as follows, and when I go to debug it highlights the red line. Public Function Conc(ID) As String ''the following was adapted from code was found at...

What about different brands? do you want to use multiple barcodes (if at all) or one barcode/brand

I'm not used to estimating lengths in metric anymore, easiest way to convert 1m ~ 1 yard (36 inches ~ 39inches) but this is only applicable to anything within 4-5 yards. If you're thinking in inches, to go to cm is just to multiply by 2.5 cm/in (actual conversion is 2.54cm/in). So for me (and...

Skipping back into the past here a little: But you have a barcode reader ready to go? If you are going to implement this database as a whole, would you not make room for a computer that is hidden near the pantry, and a dock for the barcode scanner? Why not add a neatly hidden digital scale in...

Off track maybe. Another suggestion for incorporation into the pantry DB: if you can examine the frequency that you purchase some items that are harder to keep track of (milk and juice usage for example) you could create a similar database as I mentioned before, so that when you have the DB...

A bumper sticker that would confuse many and make a few privileged individuals *facepalm* then proceed to make a judgment on your excessive internet use. Then again, others might stop you and invite you to their game of dungeons and dragons in their mother's basement later that day.

I was calling the system idiotic not you... unless you can't multiply/divide by 10. The reason I brought up the metric system is because in cooking, flour and other measurements are made in mass not volume i.e. 500g of flour instead of 1 cup of flour. If we were using this system, the whole...

I may be new to this whole internets thing... but I believe they refer to this as "trolling". Trolling, verb: the act of posting content in an effort to invoke a certain emotion within others, causing them to respond. often rage, anger, disgust, or occasionally eroticism.

ITP: Personal Rant We would not be having this problem if Americans stopped embracing this idiotic system of measurements. Trying to do this on the left side of the atlantic would involve a separate table with conversions because there is no simple way of doing conversions between fl...

I applaud the idea that the North Koreans spent the time to damage your access query. As for current events, the source of the attacks are not yet known, and they were DDOS attacks which shuts down websites, not inconvenience the average microsoft access user. As for what your issue is, I...