Search results

I would like to use code to look at each field in my form (they are all textboxes) and if it is blank, fill it with "888". I have read enough to know I should use the NZ function, but can someone tell me how it should be written to look through every textbox on the form?

In Access 97, I have a tab control with a subform on it. You enter demographics info, then jump over to the subgform (on the same tab page) and enter more specific info about that person. The parent child relationship is set up correctly. I have a drop-down list for the person to choose the...

I have tried various suggestions posted, but still can't seem to get the result I need. I have a field I have to import to a database, SS (Social Security Number). In the database I am exporting from, it is text and does not use leading zeros. In the database I am importing into, it must have...

I am putting a validation rule in my table that is In (0,1,2,3,888) or is null, with the field size as long integer. This is changed from In (0,1,2,3) or is null, which works fine. I keep getting the message Property size is too large (error 3309). Can anyone help?

I have a macro that runs behind a button on a form. When you click the button, the first thing that happens is a table containing only begin and end date is opened, what is entered in two textboxes on the form is entered, and the table is closed. Then a bunch of queries run that are based on...

I have a questionaire with 15 questions like this: DVT Prophy y n n/a Tubes y n n/a Where y=1, n=0, n/a=9. I need a query to use for a report that takes the number of responses that are either 1 or 9 (combined #) and...

I am using the following code to try and update a group of queries that all start with qryBB. It works when I use select queries and print out statements to print out any query results, but I just want to run the group of update queries, not show the user any screens or print out. Can anyone...

I have a DB with just tables, no forms. In a table I have 5 fields, Loc1, Loc 2, Loc3, Loc4, Loc5 which are text fields. I need to update into Seg1, Seg2,...which will be number fields. Problem is that Loc 1 can be 1 of 28 choices, as can Loc 2-5. Is there any way around doing 28 individual...

I have a table with imported text fields that need to be changed to number fields. I used the CInt function in an update query to change "Male" into 0. Question is, in the table design view, the field still reads as type text. I will need to do calculations on these numbers, can you tell me...

Could someone tell me the code for a function that will look at Gender from the demographics table and update it in the table to a 0 if it = "Male" or a 1 if it = "Female". Thanks in advance.

I have used a make table query to create a table with text values. I need to convert these values to numerical data, for instance "Male" should become 1 and "Female" should become 0. I tried doing this in an update query, but had to use 2 separate queries. Don't know if a macro would work to...

I have data coming from a table using an input mask for the social security number. It then goes into a query and is formatted perfectly in that query as a select query. I then change it to a make table query and have it make a table outside the current database, and in that new table the...

My report shows the department and number of cases it handled. No detail section is used. The number of cases is an unbound text box using the count function. Is there a way that I can sort the records so the units with the most "counted" cases show up first, from highest number of cases to...

I have a tbl w/ UserID, LName, FName, etc. When I try to use Find to find the last name "Whatever" for a particular record, it will NOT locate it, although it will locate the ID number and/or First name of that record. Not a typo on the last name either, so ????? All other records work fine...

In an Access 97 DB, a form that contains a memo field is being used to allow a large body of text to be pasted in it from Word. The text is in Courier Font. When the text is pasted in, all quotation marks are pasted as solid bars. Tried Times New Roman and other fonts (TT) and same result. If...

I am using the code below, and need it to do two additional things - 1) Stop at each if block and not allow the user to go on until the missing piece of information is filled in, then go on to check the other areas. As is the user gets the messagebox, but as soon as they click OK and before...

Often I receive records in Excel format that departments want converted into an Access database. One problem I often have is when trying to normalize, i.e. create a demographics table with just one set of demographic information per person, I need to be able to get rid of all the duplicate info...

I am using the code below to automate the filling in and printing out of a Word template from Access 97. I have run into a problem whereby if any field is left blank, I get a type mismatch error. The minute the field is filled in with anything, the error is gone. I would like to insert some...

I am using the code below. I do not have any fields required at this time. If the user doesn't fill out a field, I get a type mismatch error. I would like to be able to say if CatID=13, then fill in the template with the text in OthTxt, but if OthTxt is null and CatID<>13, then ignore it and...

In the following code, I get a "type mismatch" error when the field in the database is blank and the Word Bookmark has nothing to pull from for a specific record. Is there some error handling code I can use to say if any specific field is blank in the database, go on to the next field without...