Search results

I have built a main screen for inventory items, and a pop-up that displays/enters transactions for each of those inventory items. I use the following code: DoCmd.GoToRecord , , acNewRec Forms!Transaction.InventoryID = Me.ID on the pop-up event to associate the new transaction record with...

Thank you both so much for the super quick response!

The first form of my database opens up maximized, the way I want it. However, clicking to open a different form always brings up that second form maximized. For the second form: Width 3.7917" Auto Center No Auto Resize No Fit to Screen No Border Style Sizable and in Design View, the form...

I'm sorry brickelldb, I totally forgot to come back and thank you for that (it worked). Thank you for that!

I set up my databases so that F11 / Design View / etc. is disabled when someone uses it. However, I've always been able to get into the design view by holding down Shift when I double-click to open the file. However, now I get this new warning upon opening the database that I never got before...

Thanks Gemma. I'm a big fan of Access, and I'm really disappointed it apparently can't handle this well.

In other applications, I can use a SQL statement such as this: SELECT comments FROM user_col_comments WHERE table_name='tbl_Records'; to view comments linked to a table and its individual columns. I can also use a statement such as COMMENT ON COLUMN "tbl_Records"."Column" IS 'Description'...

I want to thank you all for your assistance. Stepping through the code was a great help, and as several of you guessed, some of the code was totally unnecessary. It turns out that all this macro really does is delete a bunch of information from a bunch of different worksheets, and then make a...

Thanks all, I am trying to work my way through this. Does anyone know what the "Field:=33" et al means? That seems like it should be easy to answer, and yet I can't find a thing about it nor figure it out based on the spreadsheet. noboffinme: I wish I could attach the file, but the...

I have a large Excel spreadsheet that I've been asked to expand from 25 to 100 sections. The spreadsheet has a complicated macro that was recorded. Rather than attempt to record a whole new one, I'm trying to understand the VBA so that I can modify the existing macro. Here is the first part...

That didn't quite work, but readonly=true does! Thanks!

Oh, I don't care about the color. I just want users to be able to use the scroll bar, but not modify the field contents. It doesn't need to be greyed-out as long as this is accomplished.

Thanks... With locked=true, I get the scroll bar, but I can still type in the field. With locked=true disabled=true, I get the same situation described in the first post. Is there any way to have the scroll bar but not allow typing?

Interestingly enough, the code box above is sort of like what I want to do. Scroll bar is active (although I want a vertical one, not a horizontal), and yet the text can't be edited. Is there some way to modify my own code to accomplish this?

Hello, I have the following code, which displays some non-updateable information in a text box. document.write("<table> <tr><td class='cellTitleRow' align='center' >PLAN</td></tr>"); document.write("<tr><td>"); queryObj.setParam(2,1); var worked = cmdApp.executeCommand(); var...

Thanks...I did have the main form maximized...I had no idea that would affect subsequent forms! I solved my problem by taking out the Maximize...BUT before that, I tried the Me.Restore 's, but VBA didn't seem to like them at all...any idea why?

Ohhh...There was no default value in the form, but there were zeroes as the default in the table! I didn't realize the default zeros would have been set (and didn't realize I couldn't see them from the form). Thanks!!

Note: For some reason the fields now show as zeroes...even though I do not have any default set! And it is a pain to have to highlight each zero, then type over it with the desired number. Help?

On my form I have several fields that relate back to Number columns through a query. There is no default value set for them. The fields are blank when a new record is pulled up; however, zeroes pop in for some reason once I begin entering data. For example, if I type a 1 into a blank field, a...

Nope--not only does nothing show for those events in the Properties, but there's really nothing at all in the overall code for the form.