Search results

They are active but you need to override the security on your browser. In Chrome for example I see a small shield icon appear in the link bar. I click on it and click "unload safe scripts". Then the video runs fine (for me at least).

How many records do you typically want to add? It's actually quite easily to do this using SQL.

Use IsNull() in VBA to check for null values. "Is Null" is really for SQL. As a tip you might want to consider switching your If statement round to avoid testing for negative: If IsNull(DateOfTermination) Then EndDate = Date Else EndDate =...

You could use the following: Format(Date,"yymmdd")

Here's another link http://www.w3schools.com/sql/sql_update.asp You can also use the query builder in Access to create the SQL for you. Then copy the syntax.

Did you try googling this? The first search returned was this one: https://msdn.microsoft.com/en-us/library/office/ff845036.aspx hth

I would say the wizard has found a field name that it does not like and has consequently given it a random name F7. This can happen if an illegal name is bening used e.g. one with inappropriate characters. Or if there is more that one field with the same name. Then of course once the wizard...

If you use a primary key or apply an index to your table with duplicates set to no, then the code is unnecessary. Under such conditions, duplicates will be rejected and non-duplicates will be accepted. No need to write code, just let the database engine do the work for you.

Like Tieval says, you can use DateSerial. The tricky bit is determining the last day of the month. Take a look at this: DateSerial(Year(DateAdd("m",2,date())),Month(DateAdd("m",2,date())),0) The idea here is you add two months to the current date to determine the year and month after the one...

It does seem to span the extremes. A colleague at work struggles to make ends meet yet strives to make Christmas the most magical time of year for his children. They live for this special time of year. My father passed away this year and we will ensure my mother is embroiled in our festive...

For the index problem you can apply two indexes. The first index will be based on the fields CourseID and InstructorID. The second index will be based on the fields CourseID and RoleID. For applying the constraint that the roles must be in sequence you can implement this kind of constraint...

I can see you have implemented the same approach as your other database. Are you saying it does not work? In what way? The problem with your approach is that if someone types "green" say for search Mrs Green, then they will get anyone living in Green Lane, Green Road, Greenham Common...

Might be a good time for you to provide an example of your database. I'm kind of making a few assumptions about you table structure.

Your code should look like this: Public Sub SUBPRO() Dim DBS As DAO.Database Dim rds1 As Recordset Dim rds2 As Recordset Set DBS = CurrentDb Set rds1 = DBS.OpenRecordset("invent") Set rds2 = DBS.OpenRecordset("buy_tab") Do Until rds1.EOF rds1.Edit Do Until...

I've only briefly read your post as it's not something I can help with. But it reminded me of this from MarkK. http://www.access-programmers.co.uk/forums/showthread.php?t=246115&highlight=snap

Tables don't have any sense of order. When you add records to a table then are all just one big pot of records - no order as such, regardless of the order in which they were added. You apply order using fields. The primary key will provide one order. But you can order on any field. So if you...

From what I've read so far it seems the only table that is going to get "big" is your set table. Access will happily manage a few million records in a table. There isn't a limit to the number of rows as such. It's real limit is the 2GB filesize limit that you would be constrained by. This...

Having read MarkK's response, perhaps you could show some sample data.

Try this: Sub Single_Table_Nested_Loop() Dim i As Integer Dim j As Integer Set dbs = CurrentDb Set rs1 = dbs.OpenRecordset("SELECT DISTINCT Symbol FROM ExportAAA", dbOpenDynaset) 'Outer Loop to cycle thru "Symbol" field With rs1 i = 2 'will replace with either the SymbolCount from...

Take a look here.