Search results

Hi guys, I have a form with an option group. It has 2 options. The first one has a value of 1, the second has a value of 2. This option group is named "category". Separate from this I have a query with several fields. In one of these fields, I need to enter a criteria that enters "LOE*"...

no opinions?

Hey everyone, I thought I would take a break from Access and ask you guys what you think of Falcon Northwest's Fragbook TL-2. I am currently looking for a college laptop, and I came across this the other day while surfing the web. I would love to hear your guys' thoughts and opinions! You...

Wow!!!! I deleted the current control source, and re-typed it and it magically works:eek: I have no idea why it works now, but it does. To answer your question, this text box looks at the [mindate] and [maxdate] text boxes which look up the lowest and highest dates from a table. Thanks for...

OK, I tried this, but still no luck. =DateDiff('d',[me.mindate.value],[me.maxdate.value]) Thanks, Chris

Hi everyone, This is a very simple problem, and it seems to me like it should work but it doesn't. On my form, I have a field called [mindate], which looks up the earliest date from a table. I also have a field called [maxdate] which looks up the latest date in my table. These both work...

Hi everyone, OK this is a pretty big question, but here it is.... I am not quite sure that a query is the best thing to use in this case, but I think it might be possible. Here is what I need to do: I have a table with information about oil well production. In this table the production of...

Would importing the PDF files into my .mdb file take up more disk space than putting them in a folder?....Or would it be about equal? -Chris

Hi everyone, I have been developing an invoice database system for my company. Right now they enter all the info from their invoice into an Access Database via a form. I got an idea, and am curious to if it is even possible to implement. I was thinking it would be really cool, and useful, if...

I guess I could do that... But wouldn't I still have to fill in the blank fields?

I originally wanted to fill them in so all the records would be complete in a report. Can I get by without filling them all in? -Chris

Hi everyone, I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this: API# Current Operator --------------------------------- 1 | 1 | 2...

Cool, that did work. Thanks RuralGuy! -Chris

Hey thanks for the link! I can get it to work on old records, but when my form is open and I am on a new record, it doesn't work because the autonumber ID field has not yet been generated. Any suggestions? -Chris

Hi everyone, I have a form with a date field on it. I would like the date field to automatically enter today's date, which it does now, but also I would like it to retrieve the previous record's date and if it is different from today's date, I want the form to use the previous date as the...

I am very new to Visual Basic. First, do you guys think it would be worth reading some books and learning about VB? Second, do you think it would be worth trying to duplicate one of my Access forms in VB? Thanks for your input, -Chris

Hi everyone, I have read through all of the previous posts that I can find, and I understand that it is impossible to convert an access form to an .exe file. Currently I have my database broken down into a front and back end. Is it possible to independently write a visual basic application...

Hey, that worked! That is really cool to be able to see when and who is accessing the database. Thanks once again KeithG! As far as what Doc Mann said, I know that it could happen, and it probably will, but I don't think it will be too big of a deal. I can always manually reset the table...

Wow!! That is exactly what I was looking for. You are a very skilled VB and Access developer, KeithG! That successfully completes the cool idea that I had, I couldn't have done it without you! But now that it is working, I am wondering if there is a way to list the users that are logged on...

Yes, I guess you are probably right. I hadn't thought of that, but in my case, I don't think that it would be too bad if the false positives occurred once in a while. I still would like to get this table system working so I can see it work. I really am very new to Visual Basic, so please be...