Search results

If you are trying to return a row from table 2 where the Date is either equal to the Date in table1 or the next nearest Date prior to the Date in table1 then I would not include table2 as a table in the query, just use an equation in the column to find the latest Date from table2. The only...

Add your button and in the On Click event you could add something like this: Dim NewFirst as String, NewRepeat as String If MsgBox ("Do you want to change your password?",vbYesNo,"Change Password") = vbYes Then GetNewPassWord: NewFirst = InputBox("Please enter your new password") NewRepeat =...

Here is a DB setup to send email using GMail. It is hard configured for GMail, but it can be set for any email server. Use form1 and check out the Module for more info.

It should not matter. One thing to check, the On Format event only fires when you print or print preview, not in report view. Also, you can reference the controls property more simply by using Me.ctl_label.caption = "New Caption" instead of detail.controls.item(x).caption which may become...

In the report On Open event you can test for your dummy file number and choose to not show the value by changing the controls source to null: If Me.fileNumber = 0 Then Me.FileNumber.ControlSource = "" This will leave the file number blank. I would consider using 0 or a negative number as...

Glad it helped. Please start a new post with a new question.

Creating the blank record is your solution. You only need to have 1 field filled in (should be your primary key which wouldn't get printed anyway) and the report will now show for that record as all blanks.

You can't link two tables together if both tables do not contain exactly the same data in the field you are linking them on. Are you saying that the Date in table 1 will not match the date in table 2 but somehow you want to return a previous record in table 2 when that happens?

If you would like to attach your DB I can take a look and see what my experience is.

Do you mean the DB password or a password that you created that is stored in a table?

Your table should only contain fields for raw data such as Name, Dues, Date Joined etc. Date Expired can be performed in a query as a calculation based on either Dues or Type and the Date Joined. Also consider having a field to decide if member is active or not. Attached is a DB with a report...

In the On Key Down event for the combobox add code similar to this adjusting for your control name etc.: 20 With Me.Combo1 30 Select Case KeyCode Case vbKeyDown 40 If .ListIndex < .ListCount - 1 Then 50 .Value =...

That is up to you how many lines you would like. You said you were considering adding a column to your table. If you did that then the number of lines could be based on that value. For X = 1 To Me!NumbOfLines If you need more help you can attach your DB and I can modify it.

In the After Update event for the combobox you could filter the form, for example, Me.Filter = "[StaffID]=" & Me.ComboBox1 Me.FilterOn = True

If you are using the date fields to link the two tables make the table that always has the date the From side table and left join to the table that doesn't always have a date. Then, you will need to something like you were beginning to do in the column for returning the date you will use for...

You can concatenate the fields using a function and in the query add the function as a column with whatever else is included in the data. Function Concatenate(GetKey) As String Dim Rst As DAO.Recordset, MySql As String Concatenate = "" MySql = "SELECT * FROM " & tblMilestones & " WHERE (((...

If you are using 2007 or later you can have a rich text memo field that will store formatting characters. I believe the limit for a memo field is equal to the actual DB limit of almost 2 Gig, obviously not needed for just a few paragraphs. If you want a very large box for typing but don't...

Take a look at the attached. Open the report in Print Preview for it work. Code is in the ProductID footer On Format.

Start with a clean DB, import all your queries, forms, reports, macros and modules and then import 1 table at a time, test your DB to see if you get the Sharepoint message and keep importing each table 1 at a time. If you get the sharepoint message than you know that last table is still linked...

Glad you understand. Good Luck with the rest of your project.