Search results

  1. Y

    pop up date picker?

    Hi all, I have a query and when its run I have a pop up asking for the date required. however, I cant get it to filter on that date. it asks for it, but fails to filter on it. This is what i have for the criteria <DateAdd("m",1,DateValue([enter mm/yyyy])) the date format of the field is...
  2. Y

    query any table?

    your totally 100% right Galaxiom. We are leaving MS access, the query is part of my data extraction. The company has decided to use Globalshop solutions and that uses the pervasive database. Not sure if thats the right move as its all very propriety. But thats not my decision I just have to...
  3. Y

    query any table?

    Hi there I hope you can point me in the right direction, We have a few hundered tables that have the same fields in, this was done by my predecessor. Now, I want to run a query on a few of these tables as and when needed. Could I not make just one query that has a pop up asking for the table...
  4. Y

    How Short is Short Text?

    Everything I find says it can be up to 255 chars https://support.office.com/en-gb/article/Data-types-for-Access-desktop-databases-df2b83ba-cef6-436d-b679-3418f622e482 But I have a Short text field which only allows 6 chars to be inputted? what am I missing?
  5. Y

    change form BG colour based on value

    ah perfect CJ many thanks! Private Sub Form_Current() If Result_2 = "Fail" Then Me.Detail.BackColor = 8421616 Else Me.Detail.BackColor = RGB(230, 237, 215) End If End Sub
  6. Y

    change form BG colour based on value

    Howdy, I can change the text box background colour using conditional formatting. However, I'd like the forms colour to change to red when a text field has a certain value (ie) 'fail' Is that possible google hasnt return much hope! Thanks in adavnce YouMust
  7. Y

    Filter out 'Fail'

    I'm sure it's really simple, but I just cant seem to figure it out. I have a load of test results that I want to filter in a qry so I only see passed results and not any failures. I just cant seem to get it to work at all. Here's my qry best image hosting free The 'Result' field is long text...
  8. Y

    Changing datatype

    ops bit of a typeo there sorry. Thanks plog! I guess thats the only way :)
  9. Y

    Changing datatype

    Hello, my apologies it's me again. I'm trying to change a field from long text to date/time (StartDate) to suit the actual data. the data in the field is like this: 31/12/1999 - 24:59:99 and my format is: dd/mm/yyyy - hh:nn:ss It works fine in a new field(test), but when applying it to a...
  10. Y

    Cant Sort?

    seems I'm unable to change any of them.
  11. Y

    Cant Sort?

    This table was automatically generated by labview. All of the fields are set to 'long text' but even the columns with only text in are still unsortable? I'll get the other fields changed though I'm not sure if labview will revert them back. If it does then I'll have a look at labview...
  12. Y

    Cant Sort?

    Strangely I cant sort my columns! what do?
  13. Y

    Cross platform support?

    wait, so your telling me that my predecessor purchased £2500 pounds worth of MS access for every PC for no reason! you just cant make that stuff up!
  14. Y

    Cross platform support?

    please excuse my naivety, how does one open an access front end without access installed? every pc in the company has access purchased in order to use it, or at least thats how I've inherited it. I'm still very new there's so much information it's a little overwhelming. I really appreciate...
  15. Y

    Cross platform support?

    Oh thats great news CJ, No one has a tablet yet, this is just a little idea/project to help streamline product build times, we currently use paper but when things get updated electronically, productions paper build notes often get forgotten resulting in incorrect builds. the tablets, for now...
  16. Y

    Cross platform support?

    I can be pragmatic about it and say they dont need any of the current forms on their tablets, all they'll need to do is select a product and then open the build instructions, which could be handled with simple .html tbh. Can I read and write to/from access 2013 database(is it ACE) using PHP or...
  17. Y

    Cross platform support?

    hey thanks Minty, that's a shame as access is so extensively used with everything here, my predecessor started the business with access and has grown it over the years, changing everything over to web pages from forms would represent months of work. thanks again though, I do appreciate it...
  18. Y

    Cross platform support?

    Howdy guys, I've been asked to make our access application available to production staff. With the intention of adding build notes and logging build times etc. I'm trying to think of the best way to present this information to the operators. Ideally a tablet but from what I've read so far...
  19. Y

    barcode scanner only for access

    Howdy I'm not sure if this is even possible so thought I'd ask before trying and buying a barcode reader. we need a barcode scanner to enter serial numbers in access but a piece of software doesn't play nice and takes every scan as keyboard inputs even when its minimized. Is there a way to...
  20. Y

    MDB linked to accdb?

    yes it does solve the problem :) I'm concerned as to why it was in that 'state' and what the problem is that caused it. but I may well never find out. But i'm very thankful of the help I've received! I'll take a look at that function you mentioned
Back
Top Bottom