Search results

Guys, can you assist with a database I am creating please. A bit of background... I need to create a database that records customer complaints relating to telephone call recording failures. When a call is picked up, it records directly to a channel. However, some of the calls are routed via a...

Ah it was due to an Integer value - removed single quotes from Extension = '" & Format(x,"0000") & "'") Thanks for all your help.

Morning David, It is now referencing the telephone number, but allows duplicates to be added to the extension table??

I have a table of telephone numbers that relate to an extension table, every telephone number contains multipe extensions that record individual data. I need the code to define a range of numbers but it must specifically relate to each individual telephone number.... the rest is explained in...

Hi David, The code is correct for the error message box - excellent, thanks. Unfortunately it doesn't reference specifically to the telephone number. An example: Telephone 9999 add 20 extensions results in 20 extensions being added. (i.e. no error) Telephone 3333 add 15 extensions results in...

Hi Guys, I'm attempting to create a error message to notify an end user whenever a record exists on a database. However, I'm getting an error @ "For Each record In rs.Extension" Run-time error '3251': Operation is not supported for this type of object Thanks

I've managed to get it working, cheers

Hi David, Thanks for the code. Although I've been able to amend to suit, I'm still having a issues :( I can can populate tbl_Extensions with the new extensions (e.g 1 - 10), however the telephone number from tbl_telphonenumber table (or form) won't pull across. How do I reference the first...

Hi, I've had a little success in creating the VB code, however it's the SQL string giving me issues now :( Run-time error '-2147217900(80040e14) Syntax error in INSERT INTO statement

Private Sub cmdAddRange_Click() Dim lngExtension As Long For lngExtension = Me.txtExtensionStart To Me.txtExtensionEnd CurrentProject.Connection.Execute _ "INSERT INTO Extension (Extension, Telephonenumber) " & _ "VALUES(" & lngExtension & "," & Me.Telephonenumber ");" Next lngExtension...

Thanks, it's clear now. Any help with looping thru the numbers appreciated?

Hi Namliam, The easiest way to explain would be that RefA is a telephone number and RefB relates to 30 extensions connected to the telephone number, each extension will have its own data that need to be recorded and made active/nonactive whenever a user starts/leaves the company. No. 1124...

I want to define the range by putting numbers into 2 different fields? I have telephone extension table that relates back to telephone number table, the telephone number and extension tables use a many to many set up. I want to enter the first telephone extension and the last telephone...

Guys, all comments gratefully received, even Colins! I'll try to be a little clearer with future questions.

Can anyone assist, please??:confused:

Guys, thanks for all your help so far :) The Doc Man - I'll work through your post once I get to that stage, cheers. However, I've another Q... Within a form, is there a way of creating a bulk insert of new Extensions, and then a way tracking of the new extensions? For example, 1 new...

One further Q - if this is correct, is it possible to bulk insert data from another source and how would I update the junction table along with both tables?

For 2 telephone numbers and with 10 extensions each- am I correct in saying... tbl1________________Jcttbl_______________________tbl2 TelephonePK_______tbl1FK__tbl2FK__________ExtensionPK___Extension 12345678_________12345678___1_________________1_________1...

First of all please accept my apologies for not replying sooner - hopefully I can get some further assistance! vbaInet "Unless each number in B would be referring to something?" The easiest way to explain would be that RefA is a telephone number and RefB relates to 30 extensions connected to...

Hi, I was wondering if a Db design guru could provide guidance for a db newbie?? I have to design a database (and front-end app) that contain reference numbers that relate to various groups of additional numbers. An example No. 1124 (ref A) contains 30 numbers (ref B) 01, 02, 03 ect up...