Search results

solved my problem? yes thank you :) solved my problem's certainly not :rolleyes: u know what its like :p thanks very much once again for your help

ahh it was the #'s that I was missing. I forgot about that, and yes the international date issue... -.- lets not start off with that debate everytime it pops up lol:banghead:

yeah i tried but that didnt appear to work... i mean, it changed the string but I still got the error... maybe its my SQL code? SELECT [Backup].[Created Date] FROM [Backup] WHERE [Backup].[Created Date]='02/05/2013' the error is "Data type mismatch in criteria expression"

Is there a way I can store dates in this format? dd-mm-yyyy As a Date field. if i can then I wont need to do some coding... heres the issue. I have files named in like this: "DB dd-mm-yyyy.mdb" and I cant use "/"'s in filenames. I then want to find a record that corresponds to the date...

how can I take a look at MSysObjects table? Well... I know I can go to "File > Options > CurrentDB > Navigation Options" viewing the table that way... however is there another way of being able to view the database's msysobject table? The catch is, NO ONE appart from me has Microsoft...

So i want to protect the back end of a database but im limited to what I can do.... I am unable to restrict members from accessing the file by username... I am unable to place it in a local area which is pass protected... I am also unable to encrypt the back end as the front end needs to be...

SQLstr = "SELECT TOP 1 [ID] FROM [Backup] ORDER BY [Created Date] Desc" Set rs = dbs.OpenRecordset(SQLstr) Debug.Print rs.Fields(0) This is what ive tried... but I cant seem to get the correct output I expect..

I'm looking for a way to find: ["ID"] in Requests where the criteria is the Max ["Created Date"] (the entry with the most recent date) is this possible with DLookup or should it be done using SQL?

yes the database is split up front end / back end. the normal set up of: all the data and tables are in the BACK END all the forms and queries are in the front end with the normal SQL commands to send the data from the forms into the table. However I thought once you enter the front end the...

would it matter if the database was open on another computer though? if someone left their pc on overnight with the database still up, that may cause problems correct? Also, I think I understand what you are getting at... create another access database that you run which just contains a...

but when entering in the data the email would have to be entered one at a time unless you used a complicated method of seperating each email out into a record of its own by using inStr commands to find each email address... and then it would also have to calculate how many records are needed for...

I was taking a look at this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=1206150#post1206150 and I had a few questions... Would this be possible to do even with people on the database? If not I will have to deploy a method of removing people from the database. Also...

get frustrated and angry if you want.... as long as it doesnt make you quit wanting to learn.... ill sometimes get very angry with myself for not knowing how to do something but the guys at work hate it when i shout "YES!!!" when I finally get the correct answer ;)

because I was told not to get into the habit of using DLookUp. this works fine: SQLstr = "SELECT * FROM [Packages] WHERE [Packages].[Package]='" & _ Me.Workpackagecmb.Value & "'" Set rs = dbs.OpenRecordset(SQLstr) StatusInt = rs![Status] however its now just on principle... I had...

Dim dbs As DAO.Database Dim rs As DAO.Recordset Dim SQLstr As String Set dbs = CurrentDb Dim StatusInt As Integer SQLstr = "SELECT [Status] FROM [Packages] WHERE [Packages].[Package]='" & _ Me.Workpackagecmb.Value & "'" Set rs = dbs.OpenRecordset(SQLstr) If IsNull(rs) Then...

the reason is become some will contain 1 or 2 email addresses whilst others may contain 10-20 or even more. Adding 20 boxes when most of the time a user would only need 1-2 isnt a good solution and neither is adding 5 and restricting the user. so yes the memo field would be parsed but thats...

Is there a way I can prevent wrapping in a memo field box? I have a memo field with a list of email addresses and usernames however the email addresses often just wrap around the end of the memo box just creating a new line in the memo box rather than properly showing the email without the...

Im from the south west, that makes two of us?

Is there a command that I can use to export a spreadsheet to Excel... I could use docmd.transferspreadsheet however that would also mean i would need an input window where users would need to manually put in the location they wish to save to... Instead, could i not get a "SaveAs" command...