I have tried using in the code and as a data source of an object and they both dont work. I also tried adding clicking on Insert and then Date/Time but that doesnt work either.
I am going to try using nicsin's suggestion.
How can I get today's date in M.Access? I am aware of the function =Date() but for some reason it does not return me the date (it gives #none? in return). If I use =Now() it works fine but I get the time with it which is not my interest.
Any ideas?
I keep getting this error "Data type mismatch in criteria expression" (error number 3464) when I execute the following code:
Dim Rst As Recordset
Set Rst = MyDB.OpenRecordset("SELECT * FROM Hospede WHERE Hospede.Quarto=102")
What could be wrong???
Hi.
How can I convert an integer into a string and a string into an integer? Both of these convertion are so important. I would have thought an answer to this questions would be in every VB forum... I haven't found any yet (a few broken links found in this process too)
Thats all...
CQ.
Yes... the NOW() function works perfectly though I dont want to get the time with it.
The Date() thing still doesnt work. Look what I simply wrote:
Dim t As Date
t = Date
I tried putting the parenthisis on it but once I push Enter it disappears.
When I compile it, it says library not...
Hi...
I am trying to get the system clock to inform me the date but I am having trouble with such a simple task. You may be thinking, "just click on Insert and then Date/Time". Yeah, that is what I did though for some reason it gives me #None? where it should had been the date/time...
Thanks for the response Jim.
Let me try to be a little more clear. I have the main form for my db. When I click on an object in the main form, another form pops up. Upon what I do in this child form, it should change the appearence of the main form. That is where my problem is. I don't know...
Hi,
I am new to M. Access and VB. My question is, I set a form to a table (or query) in its properties. Though sometimes I need to access a field in a different table, how do I do it programming wise? How do I get a data from a table that is not set as the "main" table.
Thanks!
The way I am getting my data right now is sending a output to the DSP telling it to grab the signal in the mic input and save it in a file or in a graph.
Right now I dont have a sampling rate. I created a loop to just keep reading in the data as fast as it can... I am pretty sure that is not...
Does anyone know a precise timer with functions like start and stop? The timer that I found in Borland you have to specify the interval, and that is not what I need. I need to time some thing and not give it a time interval.
???
Ok... I am working in a project that interfaces with a SB card. I throw a analog signal into the SoundBlaster 16 card and I have to take the data (digitalized) to analyze it for different purposes.
I got it to work using direct access to the SB card (using io.dll). The problem is that I am...
Yes... you have to disable the grid you want to empty out, do a empty table command and then enable it again. Here's the code:
Table1->Active = false;
Table1->EmptyTable();
Table1->Active = true;
If you don't disable the grid, the program will crash on you. That is the only tricky...
Ok... I understood your point of accessing the hardware.
This might go a little off topic but let me ask your opinion:
What I am doing is throwing a signal into a SB card and grabbing the data directly from the card to analyze it. The problem is that I am losing a lot of the data because I am...
How can I gather all the files needed to run a project of mine? I finished a project though when I copy the files to a disk and go to another computer to run it, there is always a file missing. Is there a way to gather all the files needed to run the program automaticly?
I know in VB there is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.