Search results

Did you ever get an answer to this Colin? I, too, am looking for a calendar that can display some bloody information, the build in access ocx just doesnt cut it.

Today I upgraded my work PC from Access 2000 (which my original database was written with) to Access 2003. Everything seems to work regularly except the following line of code. DoCmd.TransferSpreadsheet acExport, , "tblLANConnections", strBackupPath & "tblLANConnections.xls", True When I...

Heheh, I dont know, it just seems wierd being more attuned and knowledgable about structured coding than databases, and having to accept that I cant do what I wish to via code. Ive done it the way of the table and it wasnt so bad tho.. haha.

Thanks, I feared I would have to go the route of the table 8) Thanks again!

Im sure theres a billion reasons why you shouldnt do this from more seasoned access developers out there, but being a noobie, I decided to simply use 1 line of code for each table in my database.... The transferdatabase command can make a copy of whatever you desire inside of your database to...

Is there a way to use the range option to specify an all data type of condition instead of simply selecting an overly large range for a set of data that will never be the same in size? IE instead of A1:G10 in the range field, something to the effect of the dos wildcard *.* Any help would be...

Is there a way to have a variable store data and retain that data, even after access closes? Ive tried what my limited knowledge allowed me to try which was making the variable a public variable in the main module, but that didnt seem to work.. As I write this, im thinking it would be possible...

The data was simplified a bit for posting here, the key is actually a combination of the switch name, blade and port assignment which will always be a unique trio. Thank you for the concern, I will definately do alot of testing with this functionality. The information that will come into my...

Thank you... when reading this note first thing in the morning after waking up, I didnt see that there was a module in there and was a little dumbfounded. Im an access noobie, and didnt realize I could write a procedure and call it through a query. This helps me alot, and I appreciate it . The...

Thanks for the speedy replies. You could use the same technique to fill them in, using an update query and rewriting the code to supply the 1)the previous value when the value is blank and 2)echo the actual value when it is not blank; The biggest problem is that I dont fully understand how to...

Yes, its in excel, im lazy :P Data similar to this is imported into the database I am creating for my users. If you notice, in the servername field, some records have no information. Those records imply that the servername above it is the servername in question. Is there any way, via SQL to say...

Thanks again, I think this better fits my needs.

Cant believe I didnt find that... Thank you!

Cool! Thanks for the input!

For some reason I can never size a form to display the way I wish it to in the user mode. During design, I size it down, sometimes I have to overlap parts of the form with the scrollbars to get it to appear the way I want it to, and then a few form loads down the line, the form seems to grow :P...

Im nearly finished creating my first real production database, its pretty exciting! Theres a few things that I need to accomplish to consider it 100% working and im wondering if anyone has any input on the following matters: 1) Users import their data via an excel spreadsheet. Its all done...

Im actually importing the data from access, so im not sure if that command would work, but its a start, so thank you 8)

Cool, the last option was what I was using, just seemed like I was doing something... bad... by pulling 100 or so blank records into my query in the assumption that the excel worksheet wouldnt ever exceed that count. Thanks!

Nice! Thanks a ton!

Is there a cell range option that basically equates to 'all data in the worksheet that isnt blank'? IE instead of A1:N7, is there something that states "all populated cells:all populated cells"?