Search results

I have seen a number of databases that use strings for their primary key code instead of a number. Does it really matter? Are there bad consequences for using a string instead of a number for your primary key field when normalising data? Is it simply an issue of memory in that strings use...

Cool, thanks for all your suggestions!

I know you can iterate through fields in tables, can you do the same in Access forms? I'm looking to do something like: For Each control In frmName do code.. Next But not sure of the exact syntax..or if even possible to do.. Thanks for any assistance..

Never mind, I found it, I was opening it first. Apparently, you have to resize, then save, then open.. Thanks..

It was defaulted to yes.. I don't see any properties that appear to let you resize the form.. Note: It appears that in Access 2000, in design view, simply dragging the grey background space to a particular size will create the size you want the pop up dialog box to be. Is this perhaps just...

Using Access 97.. I have a modal pop-up dialog box that I can't seem to change the size of (the size when opened).. When i open it, it takes up 80% of the screen, but I only need it to be half that size. Any suggestions on how to do this?

Thanks, that works!

I have a drop down box in a form that reads 2 columns from a table. One of the columns data populates into a text box where, later it will be stored in a table. However, this value is a code value. The description value column shows in the drop down box next to the code. The user has requested...

Great idea! I'll try that..thanks..

unfortunately, the DoEvents didn't work. Any other suggestions? Am I forced to create a new button that the user has to click to continue?

I have a drop down box that once selected, populates some data in a sub form. Some controls in the main form control's source are set to the values in the sub form. What I would like to do is, after making a selection from the drop down box and AFTER those controls populate, have a msgbox...

Thanks, you don't need to fear that I have a fear of forms. I was trying to operate on the principle of ochams razor or not multiplying entities (or some form of that exhortation)..:)

version: Access 97 I was wanting to make a drop down box in code (called from code) without attaching it to a form. The drop down box would be bound to a table. I was thinking that this might be able to be done much like you can write code to create an input box. The input box doesn't have...

ok, thanks, I'll give it a shot..

I should have mentioned that I'm using Access 97, which apparently doesn't have the Replace function..any suggestions on how to proceed without this? Thanks..

Hi Wanted to know if anyone could provide some code that would go through a table and get rid of punctuation in a field? I'm looking to get rid of periods, apostrophes and commas.. Thanks for any assistance..!

Perfect, thanks!

access 97.. Hi, I have a some code in a form that is supposed to append data from a subform into a table.. I'm getting an error on the line d.execute. The error is that I have too few parameters.. Here is what the sql evaluates to in the debug window.. "insert into...

ok, thanks, that works..

I have an unbound form that contains 2 dropdown boxes and a sub form. Upon selecting a value from one of them, the subform dutifully displays associated data from the value. Name and ID for now. What I would like is (once the user selects an id and clicks a button) for the data in the subform...