Search results

Hi, past few days i've been reading up on graph DBs in my spare time and i found it quite exciting. Has anyone here had any experience with those in a business enviornment? Also, anybody knows of any examples where a company would use a graph db for their day to day work switching from a...

Hi, i'm trying to export via vba to pdf, but i can't find a way to save print margins to be a default value, which would transfer to other machines as well so that it would always output the same file on any pc. DoCmd.OutputTo acOutputForm, "FormTEST", acFormatPDF, strPath & "\Report_" &...

Hi, is it possible to export a form header along with the actual contents of the form to word? This here is my test form (not the final thing) and i've been unsucsessful thus far with keeping anything but the form data, sometimes also the lines in between records. And here is the outcome...

Hi, I've got a form for tracking repairs etc. done to PCs in our shop and i'd like to track who's checked a check-box. i got some 45-ish check boxes in there and i got a table column extra for each of these to store the data in of who did what, namely TempVars UserName, however, i figured there...

Hi, I was wondering whether it's possible to change a form's width on demand. I got a nice form with a listbox on it and i was hoping i could make it expand, namely it's width to show more data within the listbox, but only if one so desires.

Hello, I got two combo boxes next to each other, one of which is a month selector and the other a year selector. For some reason i'm unable to display the placeholder text on my month selector. I have tried various combinations such as @;"Mesic";"Mesic" to make up for the fact that it has two...

Hi, I can't find a way to run a sql code, namely this: SELECT sum(dbCash.CashTotal) FROM dbCash; and make it's output a label's .caption. Anybody knows how to do that?

Hello, I have made a second post regarding this and more here. I just want to ask seperately in a diferent Forum section as i'm not sure i chose the right one before. I would like to save a TempVars value based on a column in my account table, but i don't know how to pull that data from there...

Hello, I Pretty much need to do exactly what's in the title. I've got a "BElogon" table where i save all my User Information, there's one row for a full name which i would like to save now into a record from an unbound form where i use a simple query like this to populate the records columns...

Hi, I'm looking for a way to handle somewhat lengthy descriptions within a listbox without making the row longer but taller instead, is there a way to adjust a listbox's rows to scale automatically to the text? I'm trying to avoid listview as i have no experience with ActiveX and seeing as i...

Hi, I have a form that tracks our currently pending invoices. In order to "finalise" an invoice (set its Status from 0 to -1) i've got a pop-up form that has 3 buttons on it. Each button applies the -1 value into diferent records, one button takes a single selection from the underlying listbox...

Hi, I would like to modify the queries output value from "true;false" to a custom text, it currently outputs in my language something a direct translation would be "truth/not-truth" which is very unpleasant and disinformative for the users. Is there any way to modify this, or maybe directly...

Hello, i know about this piece of software that many people in my surroundings use, it's called "Altus Vario" and it's a business platform developed via acces, however what i don't understand is, how do they control the menu on top etc. Is that something you can normally modify within a .accdb file?

Hi, I'm using a simple query to export records based on client names. And the WHERE part of my query looks like this WHERE (((Tabule1.TabKlient)=[Formuláře]![formTabuleMini]![txtKlient])) OR ((([Formuláře]![formTabuleMini]![txtKlient]) Is Null)); (This works well, "formuláře" is a valid syntax...

Hello, I got this neat little thing somebody offered as a solution a while ago to a problem i had. It's a "do you want to save changes?" type prompt, however, on selecting "no" it always results in an error, what's wrong with it? the error is being caused by the docmd.close line apparently and...

Hi, today i've encountered the strangest error yet. I back up my project very frequently (after any major change or implementation of any kind) I had a perfectly well working front end which i have backed up and copied over to several machines. It randomly stopped working even though NOTHING has...

HI! I'm trying to have a little piece of text on my menu form which would display the currently logged in user. I handle the log in process via TempVars(UserName) but i'm unable to print it's values into text that would display on a form. Any tips on how to go about this?

Hi, is it possible to have my query pull data from the db and put it under new custom column names for the excel export? I have a db with shortcuts which are not exactly pleasant to look at by anybody but me and i would like to be able to export these under diferent names without actually hard...

Hi, I stumbled upon this guide. And i also tried the method as described in the comments which is: But i didn't manage to get that running, when i try to put the VBA code into my opening forms on load event, it gives me an error, saying "ribbon" is not valid. So my question: is there another...

Hello, I'm struggling to find a good guide on option control groups, radio buttons and check boxes mainly. I'm trying to make a month selector for a query i use for export to excel, but on my own i just wasn't able to put it together. Is there a guide somewhere, or do you have any tips on how to...