Search results

The field has just been created as a normal text field. so all the boxes are empty. i.e. I have a name field, date field etc... and also a bradfordscore field. Any ideas?

I have the following code: Dim bradfordscore As Long bradfordscore = Me.Text141 SQLText = "INSERT INTO tbl_users ([bradfordscore]) SELECT " & bradfordscore & "" DoCmd.RunSQL SQLText Can anybody see why it is coming up with 1 key violation error when run? Thanks Martin p.s...

I have the following code which works fine: LTotal = DCount("Name", "Absent", "Name = combo136.value") and also the following code which works fine: LTotal2 = DSum("Days", "Absent", "Name = combo136.value") both give me the answers I want but, in the absent table there is a column...

excellent inputbox works wonders. Thanks a lot.

All, I want a msgbox to appear (which is fine) but i want the use to be able to enter a word and then that word to be used as a variable. e.g. dayvalue = msgbox ("Enter a day", vbok) then when the user clicks on ok it will return the value that the user entered so i can use it later on in...

ok great, sorted now. cheers, great help.

I have the following line of code in a query and it returns a number value. SELECT Count(1) AS [Occasions] FROM absent WHERE (((absent.Name)="Jo")); I have pasted the following into the VBA code and it errors. How do I also get this to return a figure say into a variable or string...

ok cheers, i'll give it a go. thanks. i'll let you know if any problems.

Can somebody just tell me what is up with this line please. namevalue = Form!frm_otherusersabsentform!Combo32.Text it comes up with the error 'cannot find the field' Thanks Martin

cheers for your help. good points noted and I think i have it working now. cheers

excellent thank you very much

i mean, what do you mean by 'wrap it in # characters'?

how do you mean # characters? I am in the UK

txt_date is the first date text box and txtenddate is the second date text box. These are just normal text boxes. in the VB code it says dteStart = txt_date dteEnd = txtEndDate Dim totalstartdate As Date Dim totalenddate As Date totalenddate = dteEnd totalstartdate = dteStart Is this...

when i change the field type to text the data appears as: 1.39372822299652E-02 ideas?

in the table both fields are displaying 30th December 1899. Even though the SQL statement is passing 2 different dates to the table. Any ideas? Thanks

the sql statement i use is: [CODE] SQLText = "INSERT INTO absent ([start_date], [end_date], [days], [reason], [name]) SELECT " & totalstartdate & ", " & totalenddate & ", " & TotalBusinessDays & ", '" & reasonwhy & "', [Text18]" [\code]

I have a SQL statement that places 2 text fields into a record in a table. the text in the form is in date form, when i look at the sql statement it looks like it is putting across the date. but when i look in the table it shows 00:20:04. When in design mode the table says that field is...

excellent thanks

any ideas why?