Search results

I am trying to write a SELECT statement to count the InitPW from a table where the PWord is null and the textbox on the form "txtNewPass" is = InitPW but some reaseon this isn't working does anyone see something wrong with the below select statement Dim sqlText As String sqlText = "SELECT...

Hey, you guys I have a huge problem!!! I have a database that has linked tables. When you open the database from the SharePoint site as read-only you are still allowed to edit the tables. This can not be! At the same time some users need to able to edit the tables. How do I manage this? is is...

Is there a way if a record is missing a certain field(attachment) then open short report else open long report. Or is there a way that you can have one report with two pages and say if field(attachment) is null only open display page 1 else display page 2. I have some code like this If...

I have two reports. Short and Long. The second report has one field which is an picture embedded. I'm tryint to do something like, If field is null open short report else if field is not null open second report. Also account for the fact that multiple records can be selected to print. There...

I have a report that is two pages, the second page only has an picture embedded. This is not a required field, so If the field is null only print page 1 else print both pages. Any suggestions?

I have a report that is two pages, the second page only has an picture embedded. This is not a required field, so If the field is null only print page 1 else print both pages. Any suggestions?

I have a form that you can enter data to that saves to a table. After the record is saved, if someone decides to update/edit that entry than the record before editing should be saved to a different table so that I can have a table of all records before they are updated. Any suggestions...

Hi, How are you access developers doing? I'm in need of a little help. I have a form with 6 fields, all these fields are required. I've been trying to figure out how to not allow the user to send the email if either of the required field(s) is blank. Along with setting focus to the first field...