Search results

You said I don't need the recordset, what I don't understand now, how do I put those values from tblScale into VBA if I don't use a recordset? Other question that occured is, if I need to change the values for, lets say, dblScaleValue, and I don't use the table and recordset that means I will...

Here's what I want to do: I have a value which I enter in text field. The value type is double. I have a table in my database, that constantly holds 6 records, from which I create recordset. Here's the table with the data it holds: tblScale dblScaleValue--------dblValueFrom--------dblValueTo...

What do You mean by "hard to look at"? All the tables are in relation to the master table which is the data source to master form. What I am trying to do here is cut the need for multiple forms (for each table) by putting all in one place. What I want to do next is create a button which I will...

Can I put several subforms on main form, and then from that main form enter the data in the subforms (each subform has different table as data source) and thus add the data to different tables? Thank You.

I've created the database and everything works fine on the computer I've developed it. On some other computers I've tried it I've experienced some strange behaviours like, creating a folder that is supposed to get created when I click on the button from within database, but not during the MSI...

What button argument I need to provide, for MsgBox function, in order to create a message box that will allow me to enter the number value and the use that value? Thank You

From the database, and this backup system with exporting to excel which works on the computer I developed the database, I created package installer. When I install the application on some other machines, two things happen: Sometimes the Backup folder is created automatically during installation...

Ok, thanks for the answer. I don't have the file yet at my possession, I'm just asking in advance here. I will post it when I get it though, in the meantime I'll read about this from books. Thanks again.

Here's the scenario: I receive a mail. The mail contains text and maybe some tables, so You can treat the mail as simple .txt document. What I need to do is somehow (with some VBA function) read the entire .txt document from within the access and import specific stuff from the document. Can...

Here's what I've noticed and what is now causing me a problem. Depending on the Regional and Language Options settings in MS Windows control panel, the date I import in VBA code has different formats. When I'm on my native regioanal settings the date should be displayed in one of these two...

Thank You for Your answer David, This is definitively better method than storing the key in a visible spot such as table. I'm still having problems with other stuff I asked about earlier, and since no one answered I'll repeat my question(s) again. I'm doing this because I don't want to open...

I've read Tip 2.2 from GetProperty.txt and I add this question to my questions above: If I append the property which will store the licence key that will be evaluated with each start of the database, can someone see it (because it is a database property) from within Access, or it can only be...

[SOLVED] Difference between $cell$ and cell$ Thanks guys now it is all clear to me :)

Yes. Now I've stumbled across another example where there is only one $ sign in from of the cell letter, $E6 for example. What does this do? Thank You.

I will try this method You mentioned. What I don't know how to do is to extract the date sub string. Which functions would You use for this? Will it matter in which format is the date stored (as I see here the date is 2009-12-31)? In my database I store the date in this format dd. mmmm. yyyy...

Re: [SOLVED] Debug breakpoints don't trigger anymore?! :eek:, thank God You're on this forum Bob, cheers!

Can someone tell me what is the difference if I write $E$6 or E$6? Thank You.

[SOLVED] Debug breakpoints don't trigger anymore?! Yes Bob, that was one of the things I did before creating the distributable version of the database. Thanks again for solving my problem ;)

Maybe it's just me but I think there is some kind of problem with the database I started developing a month ago. The first version of database is finished and I made a backup of that copy. Now I want to modify something and this is what I've tried: 1) I've added one more table in which I will...

Yes I tried. The only thing that works is: after installation rename the database to .accde (back from .accdr), open the database, select the icon location form the Current Database tab, and the rename it back to .accdr. Is sagekeys free? I'm not int position to pay for installer right now so...