Search results

Guys, Sorry, forgot to mention it's sql server 2008.

Hey Guys, I've created a couple of scripts that cleans the address data from dataset 1 and 2 and then matching on a LIKE function within the join. But I'm having problems with certain values not matching due to the limitations of the LIKE function. Match Code: SELECT distinct ,ADDRESS1...

Hey guys, i have a quick question regarding forecasting. I have the following values at certain dates; 06/08/2012: 31,000 16/08/2012: 23,000 21/08/2012: 20,000 I want to forecast how long it would take to get to 10,000 and then graph it. Is there any easy way to do this? Thanks,

can anyone help? ________ TOP RATED VAPORIZERS

error occurs when i go to the end of the recordset. ________ Marijuana bubbler

Hi All, I have a form that uses network ID to identify whether a record has been created by the user on the database, but i seem to get the following error on this code: Syntax Error (missing operator in query expression) 'Staff_id ='. Private Sub Form_Current() Me.employee_lan.Value =...

Hi, I am trying to employ some security on my access 2007 db but with no user level permission i am struggling to get anything going. can someone please help provide a solution? Thanks, ________ Avandia Settlements

How do i find out what is missing? Or is there a way to reset the references to default? Thanks, ________ Glass Weed Pipe

same thing, if i go into design view of a form, and i click add exisiting fields, nothing appears. Even properties. ________ Vaporizer-Info.Com

Hi All, I recently been looking at access libraries, all of a sudden i can't seem to click properties on anything in design view, can anyone help? Thanks, ________ Michele

Hi All, I have copied a database onto a server which has windows server 2003 and the database is made in 2007. The client desktops are all windows 7 professional, but when i load up the database from a client desktop, it seems as though none of the modules / objects have been loaded thus...

thank you david, will have a play around with this ________ MEDICAL MARIJUANA CARD

I have attached the db, form is frmMain and the start/end time are present. thanks, ________ Colorado marijuana dispensary

drake, that is perfect. Just need to know how to connect to the table. thanks ________ DEPAKOTE LAWSUIT INFO

thanks for the reply. Well basically, it's like a timesheet. Intervals to be every 15mins and ranging a whole day.so ideally, the admin person would highlight 08:00 - 13:00 maintanence, 13:00-14:00 lunch and so forth. ________ Club Royal Condo Pattaya

hi All, I have two time fields (from and to) and was wondering if there was a GUI that could select time from and to via a GUI such as selecting a date from the calendar object. Thanks, ________ WEB SHOWS

all, i have the following: left([Post_Town],Instr([Post_Town] But i'm missing something, to identify the numeric value and then -1? ________ Vaporizer volcano

Hi All, I need help on a query for a post code lookup. I need to design a query whereby I only need the first part of the post code before the numeric digits start. So for example, if the post code is LE1 9PJ, it will only bring back LE. Can anyone please help? Thanks, ________ xSexyAngel live

I've just tried the formula, but it is giving me "Yes" in the value of the text box. Can anyone help? ________ Problems With Nexium

Hi All, simple question really. i have 15 text boxes with values that can range from 1-5 or have null values. How can i sum all these values up in another text box? Thanks, ________ Volcano solid valve or easy valve