Search results for query: *

Hi Guys, I am currently working on a traffic lights system for an excel spreadsheet. I have 2 date columns and a colum to indicate the colour. So Target Completion || Current Completion || Status I see the logic as.. If target completion is in the future, colour is green. If target...

Thanks very much for the help. I did attempt a vlookup but must of had something wrong as yours worked perfectly, Cheers Lopster

Hi there, I have a problem but am really unsure of which function to use to get the correct data, I have tried a number of different approaches to no avail. The spreadsheet contains a lot of data but too try and cut it short I need to this: I have a load of customer ID's in Col A. In Col M...

Hey there, The application is vb 6.0 front end and an access 97 database which is stored on a shared network drive. So really just something like If frmXXX is open display a message to say its being used by another person. Any ideas appreciated

Hi Guys, Just been looking about the net for some help with stopping multiple users accessing a particular part of an application. i.e If one user has a booking form open, the other user is informed its currently in use and cannot open it. I havent found anything very useful so was just...

Hi Guys, I have a simple Create table query but I need to set a field to a specific date format, that being dd mm yyyy. If I just leave it as default "Date" then it returns as dd/mm/yy. How can I set the data format within the Create table query string for that field? Or do I need to achieve...

Ahhh Ive finally worked this out from chance. When the temp table was created, I right clicked and exported, this also game me the option to re-create the specification file to include the new field name. After doing this the function worked perfectly. I still dont know how to view the...

Hi Guys, I have a access application which uses the TransferText method to write some data to a text file. Basically a temporary table is created, then the single record which populates it is written to the text file. If I add another field to the create table query, I get an error saying...

Hi Guys, Yeah after taking a further look into it I also realised it didnt actually make sense. But PHV your example worked perfectly, thank you.

Sorry I meant to write: ('" & listvalue & "');

Hi Guys, Im new to SQL and am trying to use the value from a list box to then use in a query. I am using the following syntax: DoCmd.RunSQL ("INSERT INTO tableName (fieldName) VALUES ('value') WHERE tableName.fieldname = ('" & listvalue "'); ) So basically in the list box they are selecting...

Hi Guys, I have a form which when loaded displays current email addresses in the database. From this screen I can add / delete email addresses, but im trying to implement a new function where I can select an email address (from the ones displayed in the listbox) and set as default. On another...

Sorry! Im pretty new to VBA and I have just realised how to do it after seeing the word Recordset! Thanks

Ok, thanks for that, just 1 more question.. Is it possible to assign the return values to variables within the query statement So if for example I had the following: "SELECT tblPersons.[Start Date], tblPersons.[Expiry Date] FROM tblPersons WHERE tblPersons.[Name] = '" & ValueName & "';"...

Hi guys, I have a combo box which is populated when an Access form is loaded. This selects all users from a particular location, and then displays the data within the combo box as Surname, FirstName. The user can then select the necessary user they are after. (So the 2 values are put together...

Ahh thank you very much, I wasnt thinking about how the individual fields would be returned, my bad. Regards

Hi guys, I've literally starting learning VBA a few days ago so plz keep that in mind:) I have learnt some of the basics, but im just looking at DAO. In the following statement, what is the purpose of the - 1 ?? Why is this needed? For i = 0 to db.TableDefs(0).Fields.Count - 1...