Search results for query: *

Hi, That makes the database client/server and I believe will resolve this issue. I am not sure if all the 40 users are ready to do this. They are asking why this error comes up after the office 2003 upgrade and they never had this before.

Hello, This is the buffer gets section of the statspack report. The statspack snapshots were taken in a 15 minute time interval. Does this mean that the query was executed 418 times in 15 minutes? The reason I am asking is another application related query in the same report was executed 40000...

Hello: Thank you. I've read it. However, I couldn't find answers to my questions there.

Hello, We have a table in access 2003 that has around 140 fields. Some records might have many fields blank. Around 50 can be blank. All the fields of a record are related to a single person. This table is called person table. Data such as person flight number, hotel adress etc are stored...

Hello.. To answer your question: The fild in the database is "Text". The list box was created from the tools box.. Thank you.

PHV, Sorry. it is actually 10 or 11 chars long. Whast I was asking is ... why didn't access raise an error when a string of larger length was inserted instead of chopping the text and causing confusion and data loss. Thanks everyone...

Hello again. Any row can be selected using the mouse in the list box display. After selecting a row, clicking the "Register" button will retrieve column(0) value and insert it into another table. At this point, Access is not returning an error if the length is greater than the field length in...

Hello, The list box control exists on a form. The form uses a query to pull the data from the database and displays all the resulting rows on the list box. The list box has columns defined in its "Column Widths" fields. Column(0) is the first field in the query.

Hello All, The data is not entered through a form. The data displays on a list box that has several columns. Text from Column(0) gets inserted into the field in the database. So, I assume no errors appear when data is inserted like this. Thanks.

Hello All, One of the fields in a table is 11 characters in length. Would access raise on error usually or truncate the input if an input string of length > 11 is inserted? In this case, access just chopped off the remaining characters without a warning causing data loss. Any comments? Thanks.

Thanks for the quick reply... Not sure if I got it right but I setup the input mask as shown above. However, the text field is stripping the - s .. How can I preserve the -s in input mask? Thanks

Hello, There's a form with a text box field "id". Length of it is 14 including two - chars. Its format is like AAA-00-0000-AA The two chars should always display in the text box. The user only enters the alphanumeric number. The text string should be "AAA-00-0000-AA". I tried input mask. It...

Hello all, I have a three page word 2003 document. The first two pages are filled up dynamically using access database data. I need the third page matter display on third page regardless of whether the first two pages are empty or full. They should not push the third page matter down. Is it...

We have a table whose text column value has to be reset to 0001 at the end of year. This column value is usually incremented everytime a form is submitted (that's when a database record is entered into another table). Therefore, it becomes 0002, 0003 etc .. After the end of year 2006, i.e this...

I am using an access form that loads the data into a word document and shows the completed ms word document. The word document can later be prined or saved. The code has several references top the word document as shown below WordObject.AppShow If WordObject.AppMinimize() Then...

Hello, I have to select only values that are numeric and length 7 from a table. Such as 1234567, 9092333 etc.. Values such as a190802, aaaaaaa, 10/2233 etc should not be selected. Any help? Thanks

Hi, Thanks. That makes sense. Don't know why the people who gave me the database have such menu dropdowns at the top. Its a problem here, but surprisingly, no one knows why all those app related menu items appear on the top like that. Don't know how the users put them or why.

Hello, Is there a way to export all tables at once instead of exporting each table/form etc manually. It would take hours to export every single item manually. Also, any idea as to why these menus appear in the database on the top? Thanks for all help.

Yeah, I presses the shift key. The menus are still there.

Thanks. It' an mdb file. I will try the export. I have to give the database back along with changes. I never did the export in access. Not sure if the exported database would look just like the original database(the custom built menus on the top). I guess I'll have to export them again back into...