Search results

This is EXACTLY what I want to do. That's it. I don't need any other service or product. I just need to link to tables that reside on a server that IS NOT PHYSICALLY in my building by any rational definition. Is there NOBODY that offers this kind of service? Can't I get some web hosting...

Hi folks. I have been working on making improvements to my employer's Access database application. It does scheduling, payroll and inventory, and it's got some pretty nice features, not to mention the upgrades I have made. Here is my issue: I want to get the data repository (it's a split...

Would the Migration Assistant be able to connect to a remote database? It's not like the database I'm connecting to exists on my work's network, there isn't a server room around the corner where I can access the rack. This is a REMOTE server, somewhere out of state, probably, and all I have is...

Oh no... is this something that I have to do on all the PC's that are going to connect to this MySQL database, or is it something I only have to do once to the front-end Access app, and then anyone that uses the app will have it? If I have to install this for every PC that's going to connect, I...

Oh boy... here's where my ignorance comes in. I have no idea. How can I find this out? Keep in mind, the MySQL database is on a hosting account, not on my PC, and not on any PC's or servers in my personal network at work.

Hi folks. I signed up for a hosting account with Hostgator, and followed their instructions for setting up a MySQL database, enabling remote connections and adding my PC's IP address as an authorized 'host'. The Hostgator account is a linux server. I have an access 2010 application (simple...

Hi guys. I have a pretty locked-down access app that opens print previews of reports whenever a user wants to see one. There isn't a button or any command for the user to send the open report to a printer (just the button that opens the report in print-preview mode), so I put "(CTRL+P TO...

Thanks to all the replies! It works! The issue was that I kept putting the [TempVars] bit within the quotes for the WHERE part of the statement, and it should have been OUTSIDE the quotes, appended with an ampersand! So instead of this: =ConcatRelated("[Data]", "tblNamesAliases"...

[SOLVED] ConcatRelated issue with TempVars Hi folks, Here's hoping somebody knows a way around this. I have a form that has a field that's supposed to fetch a list of values from a query and concatenate them. I use Allen Browne's code for this:http://allenbrowne.com/func-concat.html Here's...

Oh my God, plog, you're a genius. As it turns out, that old table (which, by the way, has multiple problems other than this one) has just over 100 duplicate records. Your solution revealed this to me right away. And as soon as I read that first sentence of yours, I was like, "Now why didn't I...

Hi folks, I have a weird problem... I have two queries that display employee records (one is based off my own employees table and one is built to display records that are still active from an older database table I imported into this database), and each has an EmployeeID value. In tblEmployees...

Hi folks. I'm trying to get a list of employees to print out correctly. I have an employees table, and each employee has a possible four different shifts I can assign them: MIDS, DAYS, NOONS and SWNG (swing shift, half on Days and half on Noons). I tried to create a query that filters my...

jdraw, that's awesome, and YES, it works. I never realized you could JOIN two fields together, I always thought it was limited to one (though don't ask me why... I often think silly things like this). Thanks so much for your help, as this has helped me solve yet another problem. To wit (for...

Yeah, I know, bad example. Again, the data I referenced in my question is not representative of the data I'm working with. It's just there to try to explain how the two tables are working with each other, and I picked a poor set of field types to try to illustrate with. I know about the...

Hi folks. I have a complex database that has lots of tables, but for the purpose of this question, I'll simplify things: I have a database with a table called Employees. Employees table has EmployeeID, Name, Date of Hire and Gender. I have a second table called WorkDays with EmployeeID...

Ah. Thanks for that, pbaldy, that helped me figure out why it wasn't working. As it turns out, the parsed string ended up malformed. Here is the correction, and this one works perfectly. Function AddAvails() TempVars("TheTime").Value = #12:00:00 AM# Do While [TempVars]![IncNumber] > 0...

[SOLVED] Incremental Times INSERT INTO statement via VBA Hi folks, I'm adding code to a button that sets some TempVars and then executes the following function: Function AddAvails() TempVars("TheTime").Value = "00:00" Do While [TempVars]![IncNumber] > 0 Dim SQL As String SQL = "INSERT...

[SOLVED] Why the heck does my IIF Time() > #11:50:00 AM# not work?? I don't understand why this isn't working. I have a text field that is supposed to show either the word "DAYS" or "NOONS", depending on the workstation's time. If it's BEFORE 11:50am, it's supposed to show "DAYS", and if it's...

I'm finding more and more often that VBA is quite a bit more simple than it's made out to be, and the VBA methods for accomplishing tasks that I've thus far been using macros for are much easier in most cases. I really need to dig further into more complicated uses of VBA and get comfortable...

Ah... as usual, I was overcomplicating it. As it turns out, you don't need quotes at all. The command is simply: DoCmd.OpenForm [TempVars]![TheFormName] I must have tried fifty different permutations with quotes. Single-Double-Single, I tried an equals sign and enclosing the whole command...