Search results

Oh, I am so stupid PosNo is a text field -- although it has numbers only, I do no calculations so left it as text and used a string variable (although of fixed length). So then I went for a 5 km run and discovered that I did not embed my string in quotes in the SQL statement -- thus...

Hi folks, I am trying to update a field that contains position number information. Position numbers are 8 characters (all numbers) and begin with either two or three zeros as placeholders. When I update the field, the preceeding zeros are all dropped. Here's the bit of code I use: Dim...

I'd suggest just one address table, with an AddressID, AddrType (either company or staff) and a Foreign key that could be used for Company/Staff Primary Key. In fact, I might go one step further and suggest just one table for all your contacts and distinguish them by contact type (either...

Just do the same thing in your report -- create calculated fields in either your query or report to create the same time frames ...

Oops, right you are. Don't use the commas round the last field. Brain cramp. Sorry about that - and glad this helped.

I'd suggest you use multiple fields, and depending on your application, and address table. How many addresses do you need for each contact? Home, Work, Cottage, Pied-a-terre? If you only need one, then I guess you could get away without a separate table.... I always use fields like...

You could try an IIF in the field on your report, sort of like this (in the data source) on the text box: =IIF(IsNull([YourcomboBox]), "All", "[YourComboBox]")

Sportsguy, you're the best Thanks again for posting the link to the other article. This worked a treat; I had it up and running in about 10 minutes. Sorry for the delay in posting back -- I was tied up sorting the Excel spreadsheet and making the Sheet match the fields in Access. If anyone...

Sportsguy, you're the best Thanks again -- I am going through the link you provided -- and I may post this to the Excel thread anyway, but will try the link first. I think this could be pretty useful - I can think of myriad examples where data collection can be done in Excel and ported to...

Thanks Sportsguy I appreciate that, thanks for sharing. This isn't really what I was looking for, unfortunately. What I have is a group of users that are collecting and manipulating financial data in Excel spreadsheets. Once the collection/manipulation is complete, I want to capture the final...

Looking for similar Hi Sportsguy -- I am trying to do something similar, and what you've done might help me immensely. What I was hoping to do was put a button in Excel that would drive the data right into a table, but I am not comfortable enough with Excel to do this. If it's not too much to...

In case you're wondering As it turns out, my problem was not dissimilar to other posts here, so I apologize, but I found a couple of pratfalls that might be worth sharing: First, I made the grevious error of writing the dates from my form to a variable field using FieldName.Text as opposed to...

Greetings: I have developed a database that is mostly working -- in Access2000 running on W2K. The database allows users to select a vehicle from a pool and book that vehicle for certain dates. The issue I have is with the date settings and the regional settings on the computers. About 40 of...

Thanks, Jon K - that works a treat! I appreciate it. Sorry to add one more posting to this topic, but it works really well (now); when users request a vehicle, I have them select a date range first, and then only the vehicles that are not booked appear in the combobox.

Hi Folks, and I apologise -- there have been a plethora of posts on this topic, most of which I have read, but I still have a question: I have a database where I want to track vehicle use, and I have 6 vehicles that can be used for any of 15 people. When a person wants a vehicle, they go to...

Me Too - With Answer AN60 -- I was trying to do the same thing, with the same results. Here's what I did: If any of the fields could potentially come up as Null, then the addition doesn't work. In the the field that could contain a null, use an IIF statement to evaluate the null and assign a...

Interesting -- and I certainly will give it a try. Somewhere in the depths of the internet I found a comment that it was not possible to update a memo field from a text box on a form beyond 127 characters if you didn't use a recordset. I can't really comment on the validity of that statement...

Greetings all, I've had a similar problem before and posted to this forum, but have rediscovered this problem. I am updating records from a form; on the form I have a text box called txtRemarks which writes to a Memo field in the database. This is the code that I use to write the query: Dim...

Thanks again -- I will remember that. In this current application, I only have two forms that I use, and I have set OpenArgs on both of them. But, this is a pretty handy way to do things -- and I'll keep error handling stuff in mind. If you have any suggestions for good sources (other than...

Strong Suit? You're right - on a couple of counts. VBA period is not my strong suit, but I am learning - and working at it - every day. That is why help from people like yourself and this forum in general is invaluable. That worked -- thank you so much! Don