Search results

Hi, I have been looking around for this for a while, but cannot seem to find an answer. I wanted to know if I have a field in access which has contents with multiple lines of test, i.e.: "Line 1 Line 2 Line 3" When I export this, it exports on one line: "Line 1 Line 2 Line 3" If there a way I...

thanks, will try both ways, I noticed that when i was looking at it and i'm sure i did something similar to pbaldy's way but knowing me I made some silly mistake lol! will post results tomorrow when I'm able to try this.

thanks, I will try that tomorrow, I thought I did it like that also and it didn't seem to work, but maybe I had a typo or something!

i may be wrong, but as far as I was aware, you can't edit data in report view, only view, you may need to create a form which looks like a report.

Hi, I am trying to open a report, where the the criteria is that the "status" field in a table is either one of the following: Awaiting Stock In-Progress On-Hold Returned to Factory RMA Requested I have tried searching for a solution to this on this forum and others, but unable to find, I'm...

Thanks a lot, I got my code working, I did like this: Dim last_id As Long Dim current_user As String last_id = DMax("[ID]", "Access Log") If IsNull(DMax("[Date_Logout]", "Access Log", "[Access Log].[ID] =" & last_id)) Then current_user = DMax("[User]", "Access Log", "[Access Log].[ID] =" &...

hi, I have a system set up which would get messed up if more then 1 person uses it, but didn't know of any pre-existing ways to do it, so, I am doing it by making a login page where the user selects who they are, this and the date and time of login are stored, and when the user closes access...

I think I saved it as mdb as I wasn't originally sure if the people with access had the new or old version. I will check on monday when i get back to work...I tried at home with an older version still in accdb and it just don't work, which is annoying! Well looks like i'll just stick to 2003...

I managed to get rid of that security message by generating a certificate in access VBA for all the forms and the install them on each PC, and select "Trust all from this publisher" :)

thanks a lot...it was looking good at the start, but then after finding how much the network here is, I keeps getting a hell of a lot of errors! Will keep looking for another way to sort it, thanks a lot though

hi guy's, when using access runtime on a PC, if i want to stop that security I enter the location in the registry as shown in an earlier post, but my database is stored on a server, so how to I enter the location of that? I tried entering the path as "\\TheServer\My Data\" but it still shows...

thanks a lot, solved a lot of my issues...only one last one!! do you know how (or if it's possible to) disable the security warning on the computer's using the Runtime instead of the full version of access? it's annoying the users! thanks

thanks for your help, just realised I have to start again anyway...justy figured out not everyone has Micrsoft Access so this won't work...re-working in excel now, hopefully can get it done in that, with a VB form

got it working...woohoo, I just missed out the "Exit sub" after the command which sometimes produced an error: Private Sub Date_Used_AfterUpdate() Form.[Ref start] = Format([Date Used], "yymm") On Error GoTo New_Number Form.[Ref end] = DMax("[Ref end]", "Reference Number", "[Reference...

yes it needs to be sequential I plan to put this on the server and people can access as an when needed. Is it possible to have a message come up that someone else is using if a second person tried to open the file? (only 8 people here though so it's very unlikely to happen anyway) Thanks

Thanks a lot for your help, it worked a treat, did it like this: Private Sub Date_Used_AfterUpdate() Form.[Ref start] = Format([Date Used], "yymm") Form.[Ref end] = DMax("[Ref end]", "Reference Number", "[Reference Number].[Ref start] = Form.[Ref start]") + 1 End Sub Only thing now, is it...

ok getting close now, I have a form which updates the Ref start, and I have make a query which groups the Ref start and outputs the last number from each group, i.e.: a table "Reference Number" with values: Ref start - Ref end 1005 - 001 1005 - 002 1006 - 001 1006 - 002 1006 - 003 1006 - 004...

hi, I am looking to try an make a access database which automatically generates the next available number based on the following: Fields Ref start Ref end User Date used Use Type Conditions 1) Ref start is the date in format "YYMM" and is based on the month for the invoice (this might be...