Search results

cheers thanks alot raskew

After having to take on the work of someone else and finding that the dates were stored as text in the format yy.mm.dd I would like to change it so it is dd/mm/yyyy and stored as a Date. I was thinking about using an update query rather than go through 10000 odd records! Any ideas?

Thanks man. You are a star! :)

I have a query to go through a table and pick up the amount of money earnt during a period then I use that field to calculate commission, but the commission field just shows up as numbers and not as currency as the set field in the table does. Is there anyway in SQL to say what sort of data type...

Try SELECT COUNT(YourTable.SerialID) AS TotalEntries FROM YourTable WHERE YourTable.YourDate = # & Format(Now(), "mm/dd/yyyy") & # Because of the american date standards the date format has to be set as that, at least ive found anyway

Ok... Here are the table structures. As each of the policies by nature have different things that they cover for, this is the reason I have made policies based on these... Otherwise the tblPolicy would be a huge table with potentionally hundreds of empty fields. tblPolicy CustCode SalesAccount...

I have an insurance policy database keeping track of insurance policy details for household and commercial shops and businesses. Tables I have are tblPolicyHousehold, tblPolicyCommercialS (Shop), tblPolicyCommercialB (Business). They each contain the following fields (the other fields they...

OK well once again, I solved it by myself... So for anyone thats interested, it involved two queries. qryInvoice: SELECT tblGroup.GroupID, tblPerson.FirstName+' '+tblPerson.LastName AS Name, tblPerson.Address1+', '+tblPerson.Address2 AS Address, qryInvoiceGroupCount.CountID AS [No in party]...

I have two tables, Group and Person. A group can hold one or more persons, linked by a field called GroupID. And a person can be a leader of a group. I want to make a query to return the leaders of the group, which I can do, ie. where tblPerson.Leader = true, but I also want to calculate the...

I have trying to export some cells in Excel which have hyperlinks in. I only want to export the path though and not the text which shows in the cell in Excel. Any ideas?

I have customers, projects and work tables. projects are linked to customer via customerid and work is linked to the project via projectid. Ok.. What I'm trying to do is make a timesheet so that work done for a specific date for any project can be retrieved and concatenated into a string or...

thx very much for your help, it worked great.

Hey guys, Anyone know how to go about catching the "Index or primary key cannot contain a Null value." message box and perhaps showing a custom message instead? Thanks in advance, Bob

No one knows how to do this?!

Generate SQL String through form values I am in the process of making a reports form for my client where they will be able to generate a query on the fly as it were. I have three radio buttons, All, Active and Inactive. So all will show both the active and inactive user accounts, active will...

Did literally just find out how to do it and was coming back to post it but you beat me to it! Tah very much anyways! Bob

Anyone got any ideas how to get the directory path where the database is running? Thx in advance Bob

You don't have access to a computer?! Well how are you going to do anything with Access at all?! Right.. as Sergeant says, you can install IIS (Internet Information Services), which is a free webserver from Microsoft, now you can have it running locally, so it doesn't even need to be accessible...

This will give you the current username Environ("Username") I don't know how to get the password they logged on with, although I think there is an example of it on the sample databases bit of the forum. I've made a Users table with usernames and yes/no fields saying which parts of the database...

Basically my boss wants it so that all changes made by staff to the database are logged. Logging the username, datachanged, form the data was changed on, and the date and time... I made a public sub but it doesnt seem to be working, any ideas? I was thinking about putting it on the afterupdate...